Afew other oddities:
1) I have a user with 2 machines; one running Win 2K the other XP. The Win 2K machine does not have this problem. The one running XP does.
2) If I do a SQLEXEC just prior to the one giving me the error; selecting from the same view without a where clause, then issuing the command giving me the error, I don't get the error!
>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
