Sorry if this is a duplicate post but there are so many I can't figure out what applies to me.
I had a .NET 2003 application that connected to an Access 2000 database using ODBC.
I upgraded this to .NET 2008 and Access 2010 in a Windows 7 environment.
My connection string used to be
"PageTimeout=5;DSN=MS Access Database;DefaultDir=" & dbpath & ";DriverId=25;DBQ="C:\MGSDATA_VB\Access_MGSDATA_2010.mdb;FIL=MS"
That gave me a data architecture error when I tried to connect.
I downloaded the Access 2010 database engine and changed the connection string to:
"Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\MGSDATA_VB\Access_MGSDATA_2010.mdb"
Now I get this message when I try to connect:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
What is the problem? I'm certain that the path on my C: drive is correct since it worked on the old version.
Thanks
I had a .NET 2003 application that connected to an Access 2000 database using ODBC.
I upgraded this to .NET 2008 and Access 2010 in a Windows 7 environment.
My connection string used to be
"PageTimeout=5;DSN=MS Access Database;DefaultDir=" & dbpath & ";DriverId=25;DBQ="C:\MGSDATA_VB\Access_MGSDATA_2010.mdb;FIL=MS"
That gave me a data architecture error when I tried to connect.
I downloaded the Access 2010 database engine and changed the connection string to:
"Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\MGSDATA_VB\Access_MGSDATA_2010.mdb"
Now I get this message when I try to connect:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
What is the problem? I'm certain that the path on my C: drive is correct since it worked on the old version.
Thanks