Connection to ODBC - DSN issue (1 Viewer)

Blancorn

Registered User.
Local time
Today, 02:22
Joined
Feb 27, 2016
Messages
30
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?
 

Attachments

  • DSN_Config.png
    DSN_Config.png
    75.4 KB · Views: 144
  • DSN_List.png
    DSN_List.png
    66.9 KB · Views: 135

CJ_London

Super Moderator
Staff member
Local time
Today, 09:22
Joined
Feb 19, 2013
Messages
16,553
nothing wrong - just more to do.You need to get and install the relevant odbc driver for whatever datasource you are using
 

Blancorn

Registered User.
Local time
Today, 02:22
Joined
Feb 27, 2016
Messages
30
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

Super Moderator
Staff member
Local time
Today, 09:22
Joined
Feb 19, 2013
Messages
16,553
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

Registered User.
Local time
Today, 02:22
Joined
Feb 27, 2016
Messages
30
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

..forever waiting... waiting for jellybean!
Local time
Today, 17:22
Joined
May 7, 2009
Messages
19,169
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

MVP / VIP
Local time
Today, 09:22
Joined
Jan 14, 2017
Messages
18,186

Users who are viewing this thread

Top Bottom