Strange Connect Problem

[Daniel Loose]

Hello,

I try to get an asp site to work on my local machine. Using ASP Studio
2005 and mssql server 2005 eval on win xp, and ms management studio.
I'm new to mssql and asp and just want to get the site to run (not
edit). have a simple connect script like

set conn = server.CreateObject("adodb.connection")
conString ="PROVIDER=SQLOLEDB;DATA SOURCE=DANIEL;DATABASE=nano;User
ID=sa;Password=yyy"

conn.open conString

what happens is that IE hangs on load. the settings in the string are
all ok I think: if I change id or pw (that is to any non-existing
user), immediately comes error like "problem logging in user sa". only
with the correct values, IE hangs. this makes me believe that the
settings are right, but that the hanging comes from anything else. any
ideas anyone? port problem? which is right? how to check? what else?
how to detect? where are error logs? how to get detailed info?

i would also be lucky with no-authentication - but
conString ="PROVIDER=SQLOLEDB;DATA
SOURCE=DANIEL;DATABASE=nano;Integrated Security=SSPI"

without uid and pw also results in hanging. so I now think the conn
strings is ok. what is wrong?? [since I am new, and just took the
project from a cd, please also ask me "stupid"
questions/suggestions!!] thank you VERY much!!!!

daniel

[Jack Vamvas]

Try :
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial
Catalog=myDataBase;User ID=myUsername;Password=myPassword;

In other words , use IP address
--

Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com/SQL


"Daniel Loose" <[e-mail] in message
news:1l********************************@4ax.com...

Hello,

I try to get an asp site to work on my local machine. Using ASP Studio
2005 and mssql server 2005 eval on win xp, and ms management studio.
I'm new to mssql and asp and just want to get the site to run (not
edit). have a simple connect script like

set conn = server.CreateObject("adodb.connection")
conString ="PROVIDER=SQLOLEDB;DATA SOURCE=DANIEL;DATABASE=nano;User
ID=sa;Password=yyy"

conn.open conString

what happens is that IE hangs on load. the settings in the string are
all ok I think: if I change id or pw (that is to any non-existing
user), immediately comes error like "problem logging in user sa". only
with the correct values, IE hangs. this makes me believe that the
settings are right, but that the hanging comes from anything else. any
ideas anyone? port problem? which is right? how to check? what else?
how to detect? where are error logs? how to get detailed info?

i would also be lucky with no-authentication - but
conString ="PROVIDER=SQLOLEDB;DATA
SOURCE=DANIEL;DATABASE=nano;Integrated Security=SSPI"

without uid and pw also results in hanging. so I now think the conn
strings is ok. what is wrong?? [since I am new, and just took the
project from a cd, please also ask me "stupid"
questions/suggestions!!] thank you VERY much!!!!

daniel