Strange Connect Problem

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

Re: Strange Connect Problem

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" wrote in message
news:1lo8f3l29lt7vvb0j4epuvqm606ppvsvos@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