COMCodeBook is totally geared to using OLEDB, not ODBC. If you use ODBC, additional layers are added in the Windows stack. YOu'll still use OLEDB, but it will look like this:

COMCodeBook->ADO->OLEDB->ODBC->database

There is MUCH more overhead and resources needed to do this. ODBC is a HUGE resource hog compared to OLEDB. You're using BOTH OLEDB and ODBC.

Also, the VFP ODBC provider has not been updated since VFP 6.0 and does not support any new VFP features added since then.

Make sure you are using the latest VFP OLEDB Provider. Unless you're doing something really bizarre in the application, it should work for everything.

>It was in ComCodeBook Craig. The code is generating an Invalid Connection string. After some checking I found that ComCodeBook is reading the configuration table and generating a ConnectionString of:
>
>"Provider=VFPOLEDB.1;Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\Mwsdata\MasterWebSystem.dbc;PWD=;UIC=sa;"
>
>Which when tried manually wil produce the error that is coming from the ComCodeBook DLL's.
>
>Changing the ComCodeBook class code to produce a connection string of:
>
>"Provider=VFPOLEDB.1;Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;Data Source=c:\Mwsdata\MasterWebSystem.dbc;PWD=;UIC=sa;"
>
>The above works to get ComCodeBook connected.
>
>But then the ComCodeBook DLL's start to break down when accessing the data tables. I now get the error:
>
>An exception occured when executing a COM method.
>...PssProcurementDataSource::ExecuteSqlQuery()
>OLE IDispatch code 0 from Microsoft OLE DB Provider for Visual FoxPro:
>Operation is invalid for a Memo, Blob, General or Picture field.. in 'PssProcurements'
>
>So either ComCodeBook is geared more toward ODBC or Ole DB has less capability than ODBC had. All the SQL calls worked for ODBC, I would hate to have to go back to test every SQL that is being used inside of ComCodeBook. But I may have to to move to Ole DB from ODBC.
>
>By the way in order for me to justify my time on this. What is the benefit to my boss of getting ComCodeBook to work with VFP OleDB versus ODBC?