Hi everyone,



I need to leave the safety of my own server now and get and update a 

recordset sitting 3 or 4,000 miles away on another IIS server.  I'm not 

sure I have any good idea of how to do that.  I know, it's probably 

elementary but if anyone would care to give me a brief sketch I would 

appreciate it a lot.



TIA

Peter

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Peter Scribner" <plscribner@e...>

Subject: [asp_database_setup] execute query against remote SQL7 DB





: Hi everyone,

: 

: I need to leave the safety of my own server now and get and update a 

: recordset sitting 3 or 4,000 miles away on another IIS server.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



You mean a remote SQL Server?



http://www.able-consulting.com/ado_conn.htm#OLEDBProviderForSQLServer



The last option there is for connecting to an SQL Server by IP address



Cheers

Ken

Sorry about the blank reply - just wanted to says thanks - that is a

terrific resource.



Gratefully,

Peter