Hello fellows,

I have to connect to a remote SQL and get data from there which is settled 
in the other server.  I tried with the IP address, but it didn't work.
How can I perform this process?
I'm seeking for your HELP desperately!!

Here is the code I used for connection.(IP address in the data source)

<!-- METADATA TYPE="typelib" 
              FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -
->
<%
  Dim objConn
  Set objConn = Server.CreateObject("ADODB.Connection")
  objConn = "Provider=SQLOLEDB; data source=000.000.0.000; " & _
            "Initial Catalog=opss; User ID=sa"
%>

try this:

objConn = "Driver={SQL
Server};Server=000.000.000.000;Database=myDatabaseName;Uid=myUsername;Pwd=my
Password;"
Maybe the IP-address has to be between curly brackets liek this:
server={000.000.000.000}

Let me know if this works, cause I'll be needing it too in de near future
:-)

Greetz,

Steven


-----Original Message-----
From: James Kim [mailto:james@k...]
Sent: woensdag 20 maart 2002 17:37
To: ASP Databases
Subject: [asp_databases] NEED HELP!!! with connecting remote SQL



Hello fellows,

I have to connect to a remote SQL and get data from there which is settled
in the other server.  I tried with the IP address, but it didn't work.
How can I perform this process?
I'm seeking for your HELP desperately!!

Here is the code I used for connection.(IP address in the data source)

<!-- METADATA TYPE="typelib"
              FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -
->
<%
  Dim objConn
  Set objConn = Server.CreateObject("ADODB.Connection")
  objConn = "Provider=SQLOLEDB; data source=000.000.0.000; " & _
            "Initial Catalog=opss; User ID=sa"
%>
_____________________________________________________________________
// free anonymous email || forums \\ subZINE || anonymous browsing
            subDIMENSION -- http://www.subdimension.com

Hi Steven,

I tried with and without the curly brackets for server's IP address,
neither worked out.
Is there any other coding I can try with?
Thanks.

www.able-consulting.com/ado_conn.htm

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "James Kim" <james@k...>
Subject: [asp_databases] Re: NEED HELP!!! with connecting remote SQL


: I tried with and without the curly brackets for server's IP address,
: neither worked out.
: Is there any other coding I can try with?

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