How to share ODBC connection from the server to the client computers?

Created an ODBC connection to the server. Going to make an Access database on a client computer and use the DSN of the server.
JOYV23Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Hypercat (Deb)Connect With a Mentor Commented:
No, each computer that is going to connect to the server database has to have its own ODBC connection.  An ODBC connection is, by definition, local only and can't be "shared" from computer to computer.
0
 
Dave BaldwinFixer of ProblemsCommented:
That doesn't make any sense.  An ODBC connection is used to connect a client to a database.  The ODBC connection must be present on the computer where the client is running.
0
 
Hypercat (Deb)Commented:
I'm not sure what your question is.  What does the ODBC connection to the server connect to - a SQL database?  What do you need to know regarding the use of the server DSN?
0
 
JOYV23Author Commented:
Just want to share the ODBC from server so I'm not going to create an ODBC to each computer. Is that possible? Setting one ODBC connection only on the server and share it to every computer? Because when they open up the Microsoft Access, it's looking for the ODBC connection.
0
 
Dave BaldwinFixer of ProblemsCommented:
@hypercat is correct, although they may each contain the same connection info, the ODBC connections are local and must be on the computers where the client program is running.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.