We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

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

Invent121
Invent121 asked
on
Medium Priority
771 Views
Last Modified: 2012-05-06
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.
Comment
Watch Question

Éric MoreauSenior .Net Consultant
CERTIFIED EXPERT
Top Expert 2016

Commented:
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?

Author

Commented:
I'm trying to use a ODBC driver to connect so I can add some linked tables in Access 2007

Commented:
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..




Éric MoreauSenior .Net Consultant
CERTIFIED EXPERT
Top Expert 2016

Commented:
Can't access link tables without using ODBC?

Author

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

Commented:
Are you able to ping the SQL Server backend when connected over the VPN?

Author

Commented:
Yes I can ping the server
This was solved by using the SQL server ODBC driver which enables you to specificy a port, (not sure named pipes works over vpn?)

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
I fixed the issue myself
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.