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%3CLINGO-SUB%20id%3D%22lingo-sub-2244456%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-2244456%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20facing%20the%20same%20problem%20while%20connecting%20.mdb%20to%20QGIS%2C%20and%20I%20tried%20all%20the%20answers%20available%20on%20the%20internet.%20The%20same%20error%20appears%20to%20me.%20Any%20leads%20would%20be%20grateful.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

 

7 Replies

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

@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,

 

 

 

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

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

@Johan_Spens 

 

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.

I am facing the same problem while connecting .mdb to QGIS, and I tried all the answers available on the internet. The same error appears to me. Any leads would be grateful.

@IsrarAhmed 

You've already tried all of the available answers? Without knowing which answers that would be, it's hard to think of some additional things to suggest. I might suggest, for example, looking for an ODBC connector for QGIS, but I don't if that is one of the things you've already tried. I also don't know if they even provide one.

 

Or I might suggest this link, but again, it may be one of those answers you already tried.

 

Good luck.