How do you connect to an SQL table at a remote site

[SBTBILL]

We are thinking about going to a co-location. What I am wondering is how would I write an ADO connection string to connect there. At this point I use a server name as the server instead of an IP address. Am being told would have to switch to an IP address.

Anybody have expierence with this?

Bill Couture

 

[Mike Lewis]

Bill,

The contents of the connection string will depend in part on the back end that you wish to use. Can you tell us what the back end will be?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[SBTBILL]

SQL server is the back end.

Bill Coture

 

[Mike Lewis]

Bill,

In that case, something like the following might be what you want:

Provider=SQLOLEDB;Data Source=<IP address goes here>;User ID=YourUsername;Password=YourPassword;

This is pretty much the minimum. There are many other options, for example the default database and various security settings.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[pthalacker]

Hi Bill,

My experience with SQL Server connections strings is that IP addresses are pretty much interchangeable with server names.

pamela