ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Question

Hi All,

When i tried to connect FoxPro .I am getting an error "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

My Connection string is :

OdbcConnection conn = new OdbcConnection();
            conn.ConnectionString =
            "Provider=VFPODBC;" +
            "SourceType=DBC;" +
            "SourceDB=C:\\Program Files\\Microsoft Visual Studio\\Vfp98\\data1.dbc;" +
            "Exclusive=No";
            conn.Open();

Please help me out to clear this task.

Thanks in Advance

---

vikas gupta

Answer 1

I believe the connection string is incorrect (no driver specified - Provider is for OLEDB). See the ODBC example at the below link:

http://www.connectionstrings.com/visual-foxpro

---

Paul ~~~~ Microsoft MVP (Visual Basic)