How to connect to a SQL sever via ODBC using a VPN connection

I'm trying to connect to a sql sever using the ODBC driver using a VPN connection, I can't seem to connect ans the driver locks up.
Invent121Asked:
Who is Participating?
 
Invent121Connect With a Mentor Author Commented:
This was solved by using the SQL server ODBC driver which enables you to specificy a port, (not sure named pipes works over vpn?)
0
 
Éric MoreauSenior .Net ConsultantCommented:
you wouldn't need to use ODBC to connect to SQL Server. it should be exactly the same thing as if the server was a local resource. what are you trying to connect to SQL Server?
0
 
Invent121Author Commented:
I'm trying to use a ODBC driver to connect so I can add some linked tables in Access 2007
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
reb73Commented:
Setup a DSN using the ODBC control panel (or ODBCAD32.exe) and test the connectivity here before invoking this DSN from MS-Access.. You can test/debug connectivity to the SQL Server using either TCP/IP or NamedPipes protocol here initially..




0
 
Éric MoreauSenior .Net ConsultantCommented:
Can't access link tables without using ODBC?

0
 
Invent121Author Commented:
I've tried setting up a DSN from the ODBC control panel first but this is where it locks up when i select the server. Ive tried the SQL Server and SQL Native client, it times out and locks up and says not reponding
0
 
reb73Commented:
Are you able to ping the SQL Server backend when connected over the VPN?

0
 
Invent121Author Commented:
Yes I can ping the server
0
 
Invent121Author Commented:
I fixed the issue myself
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.