Hi all,

I have a problem when using Access to a linked table via the Sybase ASE ODBC driver (v12.5). The database was converted from 97 to 2002 and does not experience this problem in 97.

When opening a particular linked table, I can view any record up to around 800,500. Around this point (the exact row varies) I get the error:

ODBC --call failed.

[DataDirect][ODBC Sybase Wire Protocol driver].Socket closed (#7503)

It isn't a row limit problem in Access, and the table is well under the 1GB limit (only around 200MB). I've tried all the driver workarounds provided by Sybase but still have the same problem.

Any suggestions would be greatly appreciated!!


Here is the output from the ODBC log:

History_xp 7f8-984 ENTER SQLFetch
HSTMT 07831738

History_xp 7f8-984 EXIT SQLFetch with return code -1 (SQL_ERROR)
HSTMT 07831738

DIAG [HY000] [DataDirect][ODBC Sybase Wire Protocol driver]Socket closed. (7503)

History_xp 7f8-984 ENTER SQLErrorW
HENV 078312A0
HDBC 07831348
HSTMT 07831738
WCHAR * 0x0013EB50 (NYI)
SDWORD * 0x0013EB9C
WCHAR * 0x01FD4710
SWORD 4095
SWORD * 0x0013EB88

History_xp 7f8-984 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 078312A0
HDBC 07831348
HSTMT 07831738
WCHAR * 0x0013EB50 (NYI)
SDWORD * 0x0013EB9C (7503)
WCHAR * 0x01FD4710 [ 60] "[DataDirect][ODBC Sybase Wire "
SWORD 4095
SWORD * 0x0013EB88 (60)

History_xp 7f8-984 ENTER SQLErrorW
HENV 078312A0
HDBC 07831348
HSTMT 07831738
WCHAR * 0x0013EB50 (NYI)
SDWORD * 0x0013EB9C
WCHAR * 0x01FD47A0
SWORD 4023
SWORD * 0x0013EB88

History_xp 7f8-984 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 078312A0
HDBC 07831348
HSTMT 07831738
WCHAR * 0x0013EB50 (NYI)
SDWORD * 0x0013EB9C
WCHAR * 0x01FD47A0
SWORD 4023
SWORD * 0x0013EB88