Forum Discussion
I need help to connect MS Access to ODBC.
We need more information in order to help.
Specifically, ODBC is a protocol used to connect Access to a database. So we would need to know what that database would be: SQL Server, MySQL, another accdb? or something else?
Although you indicate you've already tried everything, it would be helpful to have some examples of what you have actually tried, and what the problems were.
Thanks.
Connection failed - Check settings and try again.
Extended error information:
Unable to initialize ODBC connection to DSN for DB2,
I am trying to get ODBC to connect MS Access to QGIS. I am using 64bit on all programs, but since connection doesn't work, I have tried changing all programs to 32-bit. But it's still not connecting.
I am getting this error:
Connection failed - Check settings and try again.
Extended error information:
Unable to initialize ODBC connection to DSN for DB2,
- My DB2 is just an empty database with a table containing 3 rows of records (x, xx and xxx) to check how to get a connection with ODBC.
/JohanI have an old computer with MS Access connecting perfectly with ODBC. Using the same files does not work with Office 365.
- If it works on one computer, but not the other, and the error message includes this notice, "Unable to initialize ODBC connection to DSN for DB2", then I would recreate the DSN for that new computer.
