Craig do you know if ComCodeBook is strictly limited to ODBC when using a VFP database or can it be changed to use OleDb?
>If you have "DSN=" in your configuration string, then OLE DB will also use ODBC. If you have an OLE DB provider for the database, there is no reason to use a DSN...just use the OLEDB provider. Sounds like a change in the connection string is in order.
>
>>In the configuration table of ComCodeBook, if you are using a VFP database then the connection string Ole Db setting is MsdaSql.1. According to the documentation anyway. Should it be something else using VFP9 and the current VfpOleDb installed.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope