I'm using SQL Passthrough with an ODBC connection to a VFP DBC on a network. At a certain point in the application the SQLEXEC function fails. It's only at this one point in the application where this happens. There are a few oddities to this:
1) It only happens when the data folder is on a network drive!
2) The table is not locked. I can open another instance of VFP and issues the same select statement natively and get results. But if I try the same select statement using SQLExec, it freezes.
3) It freezes the app at this point unless I have turned on SQL Tracing in the ODBC control panel applet. With tracing turned on the SQLExec fails and I can extract this error message: "Connectivity error: Unable to retrieve specific error information. Driver is probably out of resources"
I have included a portion of the SQL Trace log that pertains to this SQLExec call, if it will help...
CONFIGVFE e7c-880 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS)
HSTMT 02034BA0
UCHAR * 0x03AFDF78 [ -3] "select cCode from vUGKIAssignments where iUGKeyIndicatorID = 100427\ 0"
SDWORD -3
CONFIGVFE e7c-880 ENTER SQLNumResultCols
HSTMT 02034BA0
SWORD * 0x0013B5CA
CONFIGVFE e7c-880 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 02034BA0
SWORD * 0x0013B5CA (7)
CONFIGVFE e7c-880 ENTER SQLNumResultCols
HSTMT 02034BA0
SWORD * 0x0013B28E
CONFIGVFE e7c-880 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 02034BA0
SWORD * 0x0013B28E (7)
CONFIGVFE e7c-880 ENTER SQLColAttributes
HSTMT 02034BA0
UWORD 1
UWORD 2
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0013B290
CONFIGVFE e7c-880 EXIT SQLColAttributes with return code 0 (SQL_SUCCESS)
HSTMT 02034BA0
UWORD 1
UWORD 2
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0013B290 (1)
CONFIGVFE e7c-880 ENTER SQLColAttributes
HSTMT 02034BA0
UWORD 1
UWORD 6
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0013B290
CONFIGVFE e7c-880 EXIT SQLColAttributes with return code 0 (SQL_SUCCESS)
HSTMT 02034BA0
UWORD 1
UWORD 6
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0013B290 (3)
CONFIGVFE e7c-880 ENTER SQLColAttributes
HSTMT 02034BA0
UWORD 1
UWORD 4
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0013B290
CONFIGVFE e7c-880 EXIT SQLColAttributes with return code 0 (SQL_SUCCESS)
HSTMT 02034BA0
UWORD 1
UWORD 4
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0013B290 (3)
CONFIGVFE e7c-880 ENTER SQLColAttributes
HSTMT 02034BA0
UWORD 1
UWORD 5
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0013B290
CONFIGVFE e7c-880 EXIT SQLColAttributes with return code 0 (SQL_SUCCESS)
HSTMT 02034BA0
UWORD 1
UWORD 5
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0013B290 (0)
CONFIGVFE e7c-880 ENTER SQLColAttributes
HSTMT 02034BA0
UWORD 1
UWORD 7
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0013B290
CONFIGVFE e7c-880 EXIT SQLColAttributes with return code 0 (SQL_SUCCESS)
HSTMT 02034BA0
UWORD 1
UWORD 7
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0013B290 (1)
CONFIGVFE e7c-880 ENTER SQLColAttributes
HSTMT 02034BA0
UWORD 1
UWORD 9
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0013B290
CONFIGVFE e7c-880 EXIT SQLColAttributes with return code 0 (SQL_SUCCESS)
HSTMT 02034BA0
UWORD 1
UWORD 9
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0013B290 (0)
CONFIGVFE e7c-880 ENTER SQLColAttributes
HSTMT 02034BA0
UWORD 1
UWORD 1
PTR 0x0013B014
SWORD 255
SWORD * 0x00000000
SQLLEN * 0x0013B290
CONFIGVFE e7c-880 EXIT SQLColAttributes with return code 0 (SQL_SUCCESS)
HSTMT 02034BA0
UWORD 1
UWORD 1
PTR 0x0013B014
SWORD 255
SWORD * 0x00000000
SQLLEN * 0x0013B290 (0)
CONFIGVFE e7c-880 ENTER SQLColAttributes
HSTMT 02034BA0
UWORD 2
UWORD 2
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0013B290
CONFIGVFE e7c-880 EXIT SQLColAttributes with return code -1 (SQL_ERROR)
HSTMT 02034BA0
UWORD 2
UWORD 2
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0013B290
DIAG [S1000] [Microsoft][ODBC Visual FoxPro Driver]Fox Error 1 (1)
CONFIGVFE e7c-880 ENTER SQLCancel
HSTMT 02034BA0
CONFIGVFE e7c-880 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 02034BA0
CONFIGVFE e7c-880 ENTER SQLErrorW
HENV 02031540
HDBC 02034908
HSTMT 02034BA0
WCHAR * 0x0013AA40 (NYI)
SDWORD * 0x0013AEF4
WCHAR * 0x0013A640
SWORD 512
SWORD * 0x0013AEFE
CONFIGVFE e7c-880 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 02031540
HDBC 02034908
HSTMT 02034BA0
WCHAR * 0x0013AA40 (NYI)
SDWORD * 0x0013AEF4
WCHAR * 0x0013A640
SWORD 512
SWORD * 0x0013AEFE
CONFIGVFE e7c-880 ENTER SQLCancel
HSTMT 02034BA0
CONFIGVFE e7c-880 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 02034BA0
CONFIGVFE e7c-880 ENTER SQLCancel
HSTMT 02034BA0
CONFIGVFE e7c-880 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 02034BA0
CONFIGVFE e7c-880 ENTER SQLCancel
HSTMT 02034BA0
CONFIGVFE e7c-880 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 02034BA0
