You absolutely do not need, nor do you want to use both OLE DB and ODBC. Why add that layer of complexity and slow down the application? Change the cProvider to use the VFP OLE DB Provider. MSDASQL is the OLE DB Provider for ODBC. Get rid of it.
>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?
>
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer