General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ODBC returns nothing!! HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
The select I run inside fox, returns data... yet the same one from another application (InterSock) returns nothing..
I turned on SQL tracking and here is a snippet from that log.
InterSock fff60c2d:fff739a1 ENTER SQLFetch
HSTMT 0x008d0ba0
InterSock fff60c2d:fff739a1 EXIT SQLFetch with return code 1 (SQL_SUCCESS_WITH_INFO)
HSTMT 0x008d0ba0
DIAG [01S01] [Microsoft][ODBC Visual FoxPro Driver]Error in row (0)
DIAG [01004] [Microsoft][ODBC Visual FoxPro Driver]Error: Column 1 ( part ) (0)
I have used the same software to query tables in an Sybase database using the SQLAnyWhere ODBC drivers and it returns the data (or no data as the case may be) see below.
InterSock fff60c2d:fff739a1 ENTER SQLFetch
HSTMT 0x008d0ba0
InterSock fff60c2d:fff739a1 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 0x008d0ba0
Any ideas what is going on?
I would hate for this to be a stumbling block for the Fox.. i.e. if Fox cannot do it, I may have to switch to PowerBuilder application development. Just so I can do the above.
Also, the command takes a long time to execute.
TIA,
Mike
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only