Monday, February 20, 2012

ODBC link across a vpn / WAN / internet link

Is it possible to achieve an ODBC link from a client pc to a remote SQL
server, either over a VPN / WAN or internet connection?
I'm looking to link a access front end to a SQL server, using a hosted
remote server.
TIAYes, it's possible and easy. However, the port 1433 (of the other one if
you set up the SQL-Server to listen to another port) must be open through
all firewalls; something that is easy to do on your side but less likely if
you are using an hosted server. For security purposes, most commercial web
hosting services will refuse to open the port 1433 through their firewall in
order to protect their sql-servers.
For OLEDB, make sure that you specify the TCP/IP protocol by indicating the
Network Library:
Provider=sqloledb;Data Source=190.190.200.100,1433;Network
Library=DBMSSOCN;Initial Catalog=myDataBase;User
ID=myUsername;Password=myPassword;
See: http://www.connectionstrings.com/?carrier=sqlserver or
http://www.carlprothman.net/Technol...br />
ult.aspx
For further explanations, take a look at the m.p.access.odbcclientsvr,
m.p.a.internet or m.p.a.externaldata newsgroups.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Fred" <fred@.blah.com> wrote in message
news:e7HoX4UQHHA.1364@.TK2MSFTNGP06.phx.gbl...
> Is it possible to achieve an ODBC link from a client pc to a remote SQL
> server, either over a VPN / WAN or internet connection?
> I'm looking to link a access front end to a SQL server, using a hosted
> remote server.
> TIA
>
>

No comments:

Post a Comment