Asp.net read file .dbf error conn.Open()

Question

file dbf: C:\myTable.dbf; code:

var file = @" C:\myTable.dbf";
var connectionString = @"Provider=vfpoledb;Data Source=" + file + ";Collating Sequence=machine;";
OdbcConnection conn = new OdbcConnection(connectionString);
conn.Open();

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

Something seems wrong in your connection string. Look at these examples - ODBC - connectionstrings.com/microsoft-visual-foxpro-odbc-driver — Steve
– Steve, Commented Sep 26, 2013 at 15:21
I'm pretty sure "Collating Sequence" isn't the right string. Try just "Collate" there. — Tamar E. Granor
– Tamar E. Granor, Commented Sep 26, 2013 at 20:50

Amitkumar Arora · Accepted Answer · 2013-09-26 15:33:33Z

1

Can you Please try changing connection string provider

try { string conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\ZIP.DBF;Extended Properties=dBase IV"; OleDbConnection conn = new OleDbConnection ( conString ); command = conn . CreateCommand ( );

     // create the DataSet
     DataSet ds = new DataSet ( );
     dataGridView1 . DataSource = null;

     // open the connection
     conn . Open ( );
     string commandString = "Select * from  ZIP.DBF";
     // run the query
     command . CommandText = commandString;
     OleDbDataAdapter adapter = new OleDbDataAdapter ( command );
     adapter . Fill ( ds );

     // close the connection
     conn . Close ( );

     // set the grid's data source
     dataGridView1 . DataSource = ds . Tables [ 0 ];
     }
 catch ( Exception ex)
     {
     MessageBox . Show (  ex . Message );

     }

answered Sep 26, 2013 at 15:33

Amitkumar Arora

1492 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2820087 Over a year ago

debug: conn.Open() --> Error: C:\myTable.dbf is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

Amitkumar Arora Over a year ago

you can put your dbf file on the other location than the c drive as on c drive have some permission issue also. and change the path in the connection string. Thank you.

Collectives™ on Stack Overflow

Asp.net read file .dbf error conn.Open()

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related