>I need to create an ADO connection to get access to a Visual FoxPro database container. I am not sure how to do this. Someone told me that I need to acquire an OLEDB provider to get to this data. Is this true? The ASP code that I am looking at for an Access database is as follows:
>
>strDBPath = Server.MapPath("db3.MDB")
>strSource = "Driver={Microsoft Access Driver (*.mdb)}"
>
>I assume that I want these statements to look something like this:
>
>strDBPath = Server.MapPath("db3.DBC")
>strSource = "Driver = {Microsoft Visual FoxPro Driver (*.dbc)}"
>
>Is there a data access pack, or some type of driver that I need to download to make this happen?
>
>Thanks for anyone's assistance in advance.
>
>Marc.
There currently is not an OLEDB provider for VFP. You will have to create an ODBC connection to your data then use the OLE-DB provider for ODBC.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer