Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 233
  • Last Modified:

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.
0
JOYV23
Asked:
JOYV23
  • 2
  • 2
1 Solution
 
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
 
Hypercat (Deb)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:
@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

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now