This is my connection to an access database in .NET:
OdbcConnection conn = new OdbcConnection("Driver={Microsoft Access Driver (*.mdb)};Dbq=" + path + "\\Access.mdb;Uid=;Pwd=;");
And I got this problem:
base {System.Data.Common.DbException} = {"ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"}
I have tried couple of database connection strings from here: http://www.connectionstrings.com/access but none of them working.
Any suggestions for this?
Thanks in advance.
There is an easy way to get the connection string, try it as follow:
.udl
.See This for more details.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With