how to connect to a remote sql server over internet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sheniece - 11 Nov 2007 04:44 GMT

Hello all, I have an access project and my back end is Sqlserver on my
local machine, the project works fine, now i would like to connect to a
remote sql server. I have already transferred the tables and storedd
procedures to a remote sql server that is being hosted. The hosting provider
has given me the connection string to connect to my database, where do i
need to add this connecting string in my code?

Reply to this Message

Albert D. Kallal - 12 Nov 2007 09:39 GMT

Are you use an adp project, or an mdb with odbc links?

if you using a mdb, then simply re-link the tables (either delete the table
links, or use some code to re-link with a DSN-less connection.

If you don't want to re-link each table by hand, then there is some example
code here:

http://www.accessmvp.com/djsteele/DSNLessLinks.html

If your using an adp project, you just go file->connection, and then can
enter the connection information.

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message

Sylvain Lafontaine - 12 Nov 2007 16:53 GMT

Most (but not all) hosting providers will forbid you to directly connect to
a sql-server over the internet (wide area network, WAN) by using a firewall;
with some exceptions that will give you access through a VPN (and other
exceptions that will give you full access without any blocking firewall).

I won't be surprised if the connection string provided is only for providing
access to your web site located on the same remote LAN (ie, for the benefit
of your ASP or ASP.NET web site).

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

> Hello all, I have an access project and my back end is Sqlserver on my
> local machine, the project works fine, now i would like to connect to a
[quoted text clipped - 3 lines]
> has given me the connection string to connect to my database, where do i
> need to add this connecting string in my code?

Reply to this Message

sheniece - 12 Nov 2007 18:10 GMT

thanks for the response Sylvain, you are correct my hosting providers won't
allow me to connect directly to the Sql server.

>Most (but not all) hosting providers will forbid you to directly connect to
>a sql-server over the internet (wide area network, WAN) by using a firewall;
[quoted text clipped - 10 lines]
>> has given me the connection string to connect to my database, where do i
>> need to add this connecting string in my code?

Reply to this Message