471,071 Members | 1,486 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,071 software developers and data experts.

sql server 2000 connection fail

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

Jun 16 '07 #1
1 1553
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

Jun 18 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by William F. O'Neill | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.