Forum Discussion
Johan_Spens
Mar 04, 2020Copper Contributor
I need help to connect MS Access to ODBC.
I need help to connect MS Access to ODBC. I need hands on help, have tried everything on the net.
Johan_Spens
Mar 05, 2020Copper Contributor
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,
Johan_Spens
Mar 05, 2020Copper Contributor
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.
/Johan
/Johan
- Johan_SpensMar 05, 2020Copper Contributor
I have an old computer with MS Access connecting perfectly with ODBC. Using the same files does not work with Office 365.
- George HepworthMar 06, 2020Steel ContributorIf 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.