SQL Anywhere ODBC Problems... 
Author Message
 SQL Anywhere ODBC Problems...

Hi.

I am using VC++4.2b and a CRecordSet derived class to access some tables
in ODBC data Sources.   I have class that was working fine when the
datasource was and MS Access ODBC source but is failing with the
SQLAnywhere ODBC driver.

I refreshed the columns and my SQL statment (which runs fine in ISQL)
but I get the following error

Error: fetching row from server.
: cannot convert testing to a int
Error in row

State:07006,Native:-157,Origin:[Sybase][ODBC Driver]
State:01S01,Native:0,Origin
:[Microsoft][ODBC Cursor Library]

Error retrieving record.

'testing' is a value from a text column in one of the tables I am
working with.

Here is the SQL statment I am running.

SELECT CompletionDate, DBA.Assignments.FlowID, FlowName,
Review, StartDate, DBA.Status.StepID, StepName, StepStatus
FROM DBA.Assignments, DBA.Status WHERE UserName = 'ciemian'
AND StepStatus in ('STARTED', 'READY', 'RESTARTED')
AND DBA.Assignments.StepID = DBA.Status.StepID

Anyone have any ideas?

thanks

Brian
--
/////////////////////////////////////////////////////
// Brian Ciemian                Phone: (617)273-6455

// PLATINUM techonoloy inc.
/////////////////////////////////////////////////////



Mon, 24 Apr 2000 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. View problem with SQL Anywhere/Adaptive Server Anywhere

2. Primary Key problem on Insert with D3, ODBC and SQL Anywhere 5

3. Sybase ODBC Driver SQL Anywhere 5.0 problem !!

4. VB 5.0, ODBC, DataControl.Recordset.Bookmark problem, SQL Anywhere

5. odbc Problems with SQL Anywhere 5.0

6. ODBC-driver for SQL Anywhere, problem with decimal-point character

7. Problem with Sybase SQL Anywhere ODBC libraries.

8. InstallShield ODBC-DAO-RDO Template and SQL Anywhere 5.0 ODBC Driver

9. DELPHI with SYBASE SQL ANYWHERE------ DELPHI with SYBASE SQL ANYWHERE

10. ODBC connection to SQL Anywhere from SQL Server 6.5

11. SQL Anywhere & ODBC to SQL (DTS)


 
Powered by phpBB® Forum Software