SCO SQLRetriever ODBC Problems

Posted in 1998

Topics: Connectivity: ODBC / JDBC / .NET

mpatrick@my-dejanews.com — Wed, 27 May 1998 17:27:22 GMT — source: Informix-list mailing list archive (1991-1998)

Hello - Has anyone had any problems with SCO SQL-Retriever, MSQuery, and MSExcel? Here is an excerpt of the Workstation-side log file indicating the errors. After the excerpt, I have explained the circumstances. ============================================================================ EXCEL bd:ad ENTER SQLAllocConnect HENV 0x00f508f0 HDBC * 0x019900b4 EXCEL bd:ad EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS) HENV 0x00f508f0 HDBC * 0x019900b4 ( 0x00f50ad0) EXCEL bd:ad ENTER SQLSetConnectOption HDBC 0x00f50ad0 UWORD 103 UDWORD 0 EXCEL bd:ad EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS) HDBC 0x00f50ad0 UWORD 103 UDWORD 0 EXCEL bd:ad ENTER SQLDriverConnectW HDBC 0x00f50ad0 HWND 0x00470164 WCHAR * 0x04a84280 [ -3] "******" SWORD -3 WCHAR * 0x04a84280 SWORD -3 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> EXCEL bd:ad EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS) HDBC 0x00f50ad0 HWND 0x00470164 WCHAR * 0x04a84280 [ -3] "******" SWORD -3 WCHAR * 0x04a84280 SWORD -3 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> EXCEL bd:ad ENTER SQLAllocStmt HDBC 0x00f50ad0 HSTMT * 0x019900b8 EXCEL bd:ad EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS) HDBC 0x00f50ad0 HSTMT * 0x019900b8 ( 0x00f437d8) EXCEL bd:ad ENTER SQLSetStmtOption HSTMT 0x00f437d8 UWORD 4 UDWORD 1 EXCEL bd:ad EXIT SQLSetStmtOption with return code -1 (SQL_ERROR) HSTMT 0x00f437d8 UWORD 4 UDWORD 1 EXCEL bd:ad ENTER SQLExecDirect HSTMT 0x00f437d8 UCHAR * 0x01990164 [ 82] "SELECT states.state_name, states.state, states.fips_state FROM states states" SDWORD 82 EXCEL bd:ad EXIT SQLExecDirect with return code -1 (SQL_ERROR) HSTMT 0x00f437d8 UCHAR * 0x01990164 [ 82] "SELECT states.state_name, states.state, states.fips_state FROM states states" SDWORD 82 EXCEL bd:ad ENTER SQLError HENV 0x00f508f0 HDBC 0x00f50ad0 HSTMT 0x00f437d8 UCHAR * 0x0012eedc (NYI) SDWORD * 0x0012eed8 UCHAR * 0x0012ed94 SWORD 256 SWORD * 0x0012eee2 EXCEL bd:ad ENTER SQLErrorW HENV 0x00f508f0 HDBC 0x00f50ad0 HSTMT 0x00f437d8 WCHAR * 0x0012ed24 (NYI) SDWORD * 0x0012eed8 WCHAR * 0x0012e924 SWORD 512 SWORD * 0x0012eee2 EXCEL bd:ad EXIT SQLErrorW with return code 0 (SQL_SUCCESS) HENV 0x00f508f0 HDBC 0x00f50ad0 HSTMT 0x00f437d8 WCHAR * 0x0012ed24 (NYI) SDWORD * 0x0012eed8 (0) WCHAR * 0x0012e924 [ 82] "[SCO Vision][ODBC Driver]Timeout expired." SWORD 512 SWORD * 0x0012eee2 (82) EXCEL bd:ad EXIT SQLError with return code 0 (SQL_SUCCESS) HENV 0x00f508f0 HDBC 0x00f50ad0 HSTMT 0x00f437d8 UCHAR * 0x0012eedc (NYI) SDWORD * 0x0012eed8 (0) UCHAR * 0x0012ed94 [ 41] "[SCO Vision][ODBC Driver]Timeout expired." SWORD 256 SWORD * 0x0012eee2 (41) EXCEL bd:ad ENTER SQLError HENV 0x00f508f0 HDBC 0x00f50ad0 HSTMT 0x00f437d8 UCHAR * 0x0012eedc (NYI) SDWORD * 0x0012eed8 UCHAR * 0x0012ed94 SWORD 256 SWORD * 0x0012eee2 EXCEL bd:ad ENTER SQLErrorW HENV 0x00f508f0 HDBC 0x00f50ad0 HSTMT 0x00f437d8 WCHAR * 0x0012ed24 (NYI) SDWORD * 0x0012eed8 WCHAR * 0x0012e924 SWORD 512 SWORD * 0x0012eee2 EXCEL bd:ad EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND) HENV 0x00f508f0 HDBC 0x00f50ad0 HSTMT 0x00f437d8 WCHAR * 0x0012ed24 (NYI) SDWORD * 0x0012eed8 WCHAR * 0x0012e924 SWORD 512 SWORD * 0x0012eee2 EXCEL bd:ad EXIT SQLError with return code 100 (SQL_NO_DATA_FOUND) HENV 0x00f508f0 HDBC 0x00f50ad0 HSTMT 0x00f437d8 UCHAR * 0x0012eedc (NYI) SDWORD * 0x0012eed8 UCHAR * 0x0012ed94 SWORD 256 SWORD * 0x0012eee2 EXCEL bd:ad ENTER SQLFreeStmt HSTMT 0x00f437d8 UWORD 1 <SQL_DROP> EXCEL bd:ad EXIT SQLFreeStmt with return code -1 (SQL_ERROR) HSTMT 0x00f437d8 UWORD 1 <SQL_DROP> EXCEL bd:ad ENTER SQLDisconnect HDBC 0x00f50ad0 EXCEL bd:ad EXIT SQLDisconnect with return code -1 (SQL_ERROR) HDBC 0x00f50ad0 EXCEL bd:ad ENTER SQLFreeConnect HDBC 0x00f50ad0 EXCEL bd:ad EXIT SQLFreeConnect with return code -1 (SQL_ERROR) HDBC 0x00f50ad0 EXCEL bd:ad ENTER SQLFreeEnv HENV 0x00f508f0 EXCEL bd:ad EXIT SQLFreeEnv with return code -1 (SQL_ERROR) HENV 0x00f508f0 ============================================================================ This timeout error occurs ONLY THE FIRST TIME in an application, and subsequent calls perform correctly. MSQuery, however, never returns data to MSExcel because MSQuery is called fresh each time it is requested from Excel. A saved query which is run in Excel returns the timeout error the first time, but then runs correctly subsequent times. I have contacted SCO Support about the problem, but they could not help me because SQLGold successfully pulled data from the Informix database on the SC