Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-14-2019, 01:19 PM   #1
Blancorn
Newly Registered User
 
Join Date: Feb 2016
Posts: 20
Thanks: 1
Thanked 0 Times in 0 Posts
Blancorn is on a distinguished road
Connection to ODBC - DSN issue

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?
Attached Images
File Type: png DSN_Config.png (75.4 KB, 25 views)
File Type: png DSN_List.png (66.9 KB, 23 views)

Blancorn is offline   Reply With Quote
Old 07-14-2019, 01:44 PM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,344
Thanks: 40
Thanked 3,670 Times in 3,538 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Connection to ODBC - DSN issue

nothing wrong - just more to do.You need to get and install the relevant odbc driver for whatever datasource you are using
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 07-14-2019, 01:51 PM   #3
Blancorn
Newly Registered User
 
Join Date: Feb 2016
Posts: 20
Thanks: 1
Thanked 0 Times in 0 Posts
Blancorn is on a distinguished road
Re: Connection to ODBC - DSN issue

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?

Blancorn is offline   Reply With Quote
Old 07-14-2019, 03:40 PM   #4
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,344
Thanks: 40
Thanked 3,670 Times in 3,538 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Connection to ODBC - DSN issue

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
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 07-14-2019, 08:37 PM   #5
Blancorn
Newly Registered User
 
Join Date: Feb 2016
Posts: 20
Thanks: 1
Thanked 0 Times in 0 Posts
Blancorn is on a distinguished road
Re: Connection to ODBC - DSN issue

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.
Blancorn is offline   Reply With Quote
Old 07-14-2019, 09:15 PM   #6
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Connection to ODBC - DSN issue

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).
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 07-14-2019, 09:48 PM   #7
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,287
Thanks: 115
Thanked 3,089 Times in 2,807 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Connection to ODBC - DSN issue

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/...nked-tables-in
Another good guide is at http://www.accessmvp.com/DJSteele/DSNLessLinks.html


__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC Connection Issue SazzleTWG SQL Server 2 06-03-2013 12:10 AM
Issue with Pass through Query and ODBC connection pradeep.atta Modules & VBA 2 01-16-2013 01:16 PM
Secure connection using ODBC connection latex88 General 1 08-19-2012 08:14 AM
ODBC connection christshis General 11 06-26-2006 05:21 AM
Database security - ODBC connection issue jancliff General 0 07-13-2005 04:02 AM




All times are GMT -8. The time now is 01:05 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World