Connection to ODBC - DSN issue (1 Viewer)

[Blancorn]

Hello everyone,

I'm trying to connect my access database to the ODBC.
System DSN was created by the owner of ODBC I'm connecting to (DSN_Config - screen attached).


Unfortunatelly when I want to establish connection in Access to the ODBC through this DSN, it is not on the list (DSN_List - screen attached).

Do you have any idea what am I doing wrong?

 

[CJ_London]

nothing wrong - just more to do.You need to get and install the relevant odbc driver for whatever datasource you are using

 

[Blancorn]

What do you mean by "relevant ODBC driver"?

I'm trying to connect my Access databse to the company ERP system - what kind of drivers should look for?

 

[CJ_London]

you'll have to ask your IT dept. Could be pretty much anything. Whilst at it, you will probably need to know about passwords and usernames as well

 

[Blancorn]

Would anyone be interested to help me connect my access database to this ODBC? Looks that I need step by step support - I'm ready to pay for your support.

 

[arnelgp]

like said before, you ask your IT what database are you using for your ERP, oracle, mssql, etc..

then you download and install the latest odbc client driver for that database.
then you can use the odbc wizard on your computer (admin tools).

 

[isladogs]

Do bear in mind that you will need to setup the ODBC connection on each workstation running your FE.

An alternative approach uses DSN less connections.
Possibly slightly trickier to setup the first time but a huge advantage is that it only needs to be done once.
For example see https://support.microsoft.com/en-gb/help/892490/how-to-create-a-dsn-less-connection-to-sql-server-for-linked-tables-in
Another good guide is at http://www.accessmvp.com/DJSteele/DSNLessLinks.html