connect to remote SQL DB

[plook]

Hi there..

I am trying to set up a connection to my database from a different server, but i'm having difficulties.

I was given this code to connect...

"
<%
Set conn = Server.CreateObject(&quot;ADODB.Connection&quot
DSNtemp=&quot;DRIVER={SQL Server};SERVER=ServerName;UID=USER;PWD=password;DATABASE=databasename&quot;
conn.open DSNtemp
%>
&quot;

It looks cool, but, can I put the IP of the server instead of the &quot;ServerName&quot; ? If I can't put the IP, what would I need to do in order to connect to a remote DB like that ?

Thanks for your help

Dominic

 

[codestorm]

yes you can put the server ip there, and make sure any firewalls in between allow access on the sql server port (1433 or some such from memory) codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>