I’m testing connection in OTL Example 21 and I’m using this connection string:
db.rlogon("Driver = { Microsoft Access Driver (.mdb, .accdb) }; DBQ = D:\mine.accdb;");
I’m getting an error message as in attached log file:
“[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified”
Did try different connection strings from https://www.connectionstrings.com/access. Nothing helps.
Example 21 built as x64, UNICODE.
Access database created in Access from Office 2016. I did installed it as x64 but in Task Manager Access reported as x86.
I saw discussions on OTL website, looks like OTL cannot connect to Access without DSN. Is it correct?
Thank you
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The message definitely says that the ODBC DSN wasn't found. Not sure why. You may want to create a 64-bit ODBC DSN via the ODBC Drivere Manager, and try that ODBC DSN in otl_connect::rlogon().
Sergei
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I’m testing connection in OTL Example 21 and I’m using this connection string:
db.rlogon("Driver = { Microsoft Access Driver (.mdb, .accdb) }; DBQ = D:\mine.accdb;");
I’m getting an error message as in attached log file:
“[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified”
Did try different connection strings from https://www.connectionstrings.com/access. Nothing helps.
Example 21 built as x64, UNICODE.
Access database created in Access from Office 2016. I did installed it as x64 but in Task Manager Access reported as x86.
I saw discussions on OTL website, looks like OTL cannot connect to Access without DSN. Is it correct?
Thank you
Gennady,
The message definitely says that the ODBC DSN wasn't found. Not sure why. You may want to create a 64-bit ODBC DSN via the ODBC Drivere Manager, and try that ODBC DSN in otl_connect::rlogon().
Sergei