Posted by Jack Vamvas on 09/24/07 07:35

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" <no@reply.de> 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

[Back to original message]