I need help to connect MS Access to ODBC.

%3CLINGO-SUB%20id%3D%22lingo-sub-1209170%22%20slang%3D%22en-US%22%3EI%20need%20help%20to%20connect%20MS%20Access%20to%20ODBC.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1209170%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20need%20help%20to%20connect%20MS%20Access%20to%20ODBC.%20I%20need%20hands%20on%20help%2C%20have%20tried%20everything%20on%20the%20net.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1209170%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1209444%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20to%20connect%20MS%20Access%20to%20ODBC.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1209444%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F574386%22%20target%3D%22_blank%22%3E%40Johan_Spens%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20need%20more%20information%20in%20order%20to%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESpecifically%2C%20ODBC%20is%20a%20protocol%20used%20to%20connect%20Access%20to%20a%20database.%20So%20we%20would%20need%20to%20know%20what%20that%20database%20would%20be%3A%20SQL%20Server%2C%20MySQL%2C%20another%20accdb%3F%20or%20something%20else%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlthough%20you%20indicate%20you've%20already%20tried%20everything%2C%20it%20would%20be%20helpful%20to%20have%20some%20examples%20of%20what%20you%20have%20actually%20tried%2C%20and%20what%20the%20problems%20were.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1210932%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20to%20connect%20MS%20Access%20to%20ODBC.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1210932%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46682%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EConnection%20failed%20-%20Check%20settings%20and%20try%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExtended%20error%20information%3A%3C%2FP%3E%3CP%3EUnable%20to%20initialize%20ODBC%20connection%20to%20DSN%20for%20DB2%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20get%20ODBC%20to%20connect%20MS%20Access%20to%20QGIS.%20I%20am%20using%2064bit%20on%20all%20programs%2C%20but%20since%20connection%20doesn't%20work%2C%20I%20have%20tried%20changing%20all%20programs%20to%2032-bit.%20But%20it's%20still%20not%20connecting.%3C%2FP%3E%3CP%3EI%20am%20getting%20this%20error%3A%3C%2FP%3E%3CP%3EConnection%20failed%20-%20Check%20settings%20and%20try%20again.%3C%2FP%3E%3CP%3EExtended%20error%20information%3A%3C%2FP%3E%3CP%3EUnable%20to%20initialize%20ODBC%20connection%20to%20DSN%20for%20DB2%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1210991%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20to%20connect%20MS%20Access%20to%20ODBC.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1210991%22%20slang%3D%22en-US%22%3EMy%20DB2%20is%20just%20an%20empty%20database%20with%20a%20table%20containing%203%20rows%20of%20records%20(x%2C%20xx%20and%20xxx)%20to%20check%20how%20to%20get%20a%20connection%20with%20ODBC.%3CBR%20%2F%3E%2FJohan%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1211049%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20to%20connect%20MS%20Access%20to%20ODBC.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1211049%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20old%20computer%20with%20MS%20Access%20connecting%20perfectly%20with%20ODBC.%20Using%20the%20same%20files%20does%20not%20work%20with%20Office%20365.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F574386%22%20target%3D%22_blank%22%3E%40Johan_Spens%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1213665%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20to%20connect%20MS%20Access%20to%20ODBC.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1213665%22%20slang%3D%22en-US%22%3EIf%20it%20works%20on%20one%20computer%2C%20but%20not%20the%20other%2C%20and%20the%20error%20message%20includes%20this%20notice%2C%20%22Unable%20to%20initialize%20ODBC%20connection%20to%20DSN%20for%20DB2%22%2C%20then%20I%20would%20recreate%20the%20DSN%20for%20that%20new%20computer.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I need help to connect MS Access to ODBC. I need hands on help, have tried everything on the net.

 

5 Replies
Highlighted

@Johan_Spens 

 

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.

Highlighted

@George Hepworth 

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,

 

 

 

Highlighted
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
Highlighted

I have an old computer with MS Access connecting perfectly with ODBC. Using the same files does not work with Office 365.

@Johan_Spens 

 

Highlighted
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.