sql server 2000 connection fail

[finn clement hansen]

Hi group,

being pretty new to setting up sql server, I am stuck.

Have installed sql 2000 server on Win 2000 server, IIS 5.0. I try to connect via ASP script that looks like this:

<%
Set Conn = Server.CreateObject("ADODB.Connection")
ConStr = "PROVIDER=SQLOLEDB; DATA SOURCE=192.168.1.99"
ConStr = ConStr & ";UID=someUser;PWD=somePassword"
ConStr = ConStr & ";initial catalog=myDatabaseName;network library=DBMSSOCN"
Conn.Open ConStr
Conn.Close

Set Conn = Nothing
%>

The IP number is the webserver my router points to on port 80.

But get an HTTP 500 error and "The page cannot be displayed"

Any suggestions as to what I am doing wrong here, would be very much appreciated.

I have run applications for a long time that operate Access databases, but starting a new, an big project, forces me to upgrade to sql databases.

Best wishes
FCH

[finn clement hansen]

Hi! Don't bother. I solved the problem myself. Needed to change authentication - and "UID" to "user id".

But thanks anyway.

FCH
"finn clement hansen" <fi**@clement-it.comskrev i en meddelelse news:yg*************@news.get2net.dk...
Hi group,

being pretty new to setting up sql server, I am stuck.

Have installed sql 2000 server on Win 2000 server, IIS 5.0. I try to connect via ASP script that looks like this:

<%
Set Conn = Server.CreateObject("ADODB.Connection")
ConStr = "PROVIDER=SQLOLEDB; DATA SOURCE=192.168.1.99"
ConStr = ConStr & ";UID=someUser;PWD=somePassword"
ConStr = ConStr & ";initial catalog=myDatabaseName;network library=DBMSSOCN"
Conn.Open ConStr
Conn.Close

Set Conn = Nothing
%>

The IP number is the webserver my router points to on port 80.

But get an HTTP 500 error and "The page cannot be displayed"

Any suggestions as to what I am doing wrong here, would be very much appreciated.

I have run applications for a long time that operate Access databases, but starting a new, an big project, forces me to upgrade to sql databases.

Best wishes
FCH