I am using the built in ConnCfg table in the DataSource Project. In the table I have the follwoing fields set:
cIndex = prm_Connection_Vfp
cConnectTo = ""
cDataSrc = "C:\MwsData\MasterWebSystem.Dbc"
cInitcat = ""
cPassword = ""
cSecInfo = ""
cProvider = "MSDASQL.1"
cUserId = "sa"
I would assume that I just change the cProvider to "VfpOleDb.1" but I don't think that will quite get it. Do I need both VfpOleDb for VFP9 and an ODBC Driver installed?
>COM Codebook was designed to use OLE DB.
>
>What's the connection string you are using?
>
>>I do have the Vfp OleDB provider installed. I will be investigating COM Code Book to see if I can have it take advantage of it versus ODBC. But since I did not write Com CodeBook it will take me a little time to investigate if it can be done. The documentation makes it look like I just change providers in a configuration table used inside of the COM Code Book project. But so far it has not worked. I wont install the ODBC driver until I know for sure that the VFPOleDB driver does not work with COM Code Book.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope