sql server 2000 connection fail

This is a multi-part message in MIME format.

------=_NextPart_000_001E_01C7B01E.F8ACCC50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi group,

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

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 =3D Server.CreateObject("ADODB.Connection")
ConStr =3D "PROVIDER=3DSQLOLEDB; DATA SOURCE=3D192.168.1.99"
ConStr =3D ConStr & ";UID=3DsomeUser;PWD=3DsomePassword"=20
ConStr =3D ConStr & ";initial catalog=3DmyDatabaseName;network =
library=3DDBMSSOCN"
Conn.Open ConStr
Conn.Close

Set Conn =3D 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

------=_NextPart_000_001E_01C7B01E.F8ACCC50
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">

Re: sql server 2000 connection fail

This is a multi-part message in MIME format.

------=_NextPart_000_000F_01C7B17B.AD29F3D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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" skrev i en meddelelse =
news:ygQci.22$f63.20@news.get2net.dk...
Hi group,

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

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 =3D Server.CreateObject("ADODB.Connection")
ConStr =3D "PROVIDER=3DSQLOLEDB; DATA SOURCE=3D192.168.1.99"
ConStr =3D ConStr & ";UID=3DsomeUser;PWD=3DsomePassword"=20
ConStr =3D ConStr & ";initial catalog=3DmyDatabaseName;network =
library=3DDBMSSOCN"
Conn.Open ConStr
Conn.Close

Set Conn =3D 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

------=_NextPart_000_000F_01C7B17B.AD29F3D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">

style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"finn clement hansen" < href=3D"mailto:finn@clement-it.com">finn@clement-it.com> skrev =
i en=20
meddelelse =
href=3D"news:ygQci.22$f63.20@news.get2net.dk">news:ygQci.22$ f63.20@news.g=
et2net.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=20
connect via ASP script that looks like this:

 

<%
Set Conn =
Server.CreateObject("ADODB.Connection")
ConStr =3D =
"PROVIDER=3DSQLOLEDB; DATA=20
SOURCE=3D192.168.1.99"
ConStr =3D ConStr =
&=20
";UID=3DsomeUser;PWD=3DsomePassword"
ConStr =3D ConStr & =
";initial=20
catalog=3DmyDatabaseName;network library=3DDBMSSOCN"
Conn.Open=20
ConStr
Conn.Close

Set Conn =3D Nothing
%>

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

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

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

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

Best wishes
color=3D#000000=20
size=3D3>FCH