visual foxpro connection string

Question

i have to extract some data from a foxpro database. I found a sample app that extracts data from a sql server db and stores the connection string in the app.config file in the following format -

<connectionStrings>
    <add name="test"
       connectionString="Data Source=localhost\SQLExpress;Initial Catalog=test;Integrated Security=SSPI;Timeout=300;"
       providerName="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
  </connectionStrings>

I would like to do the same thing in foxpro, but i don't know what to put for the providerName part of the configuration. i can get the connection string just fine. Does anyone have any idea what the provider name would be for visual foxpro?

Thanks

Conrad Frix Conrad Frix · Accepted Answer · 2010-10-27T19:00:40

You'll need to download the VFP Provider

Then according to connection strings the connection string will be

Provider=vfpoledb;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine;

The provider name would be System.Data.OleDb

visual foxpro connection string

2 Answers