Hi.

I have just installed my webapplication on my ISP`s webserver with a connection to a SQL Server on the same server. My problem is that my app. cant find the database from the webserver. When I make a connection to the same db from my application running on my machine locally there is no problem. However, when i try to run the application on the webserver I get an error like this: SQL Server not found or access denied. When the remote db connection works from my machine, why doesn`t it work from tha webserver where the db is located. I use the same connection string:

"data source=gryllefjord.chriskomm.no;initial catalog=felicitas_new;persist security info=False;user id=myId;password:myPass;packet size=4096"

Can someone please help me?


Thanks!

Regards,
Knut

I think in your connection string the password field should be 'password=myPass;' not 'password:myPass;'

Good luck!

Qadeer

Yes, In the connection string i use it`s: password=myPass
I typed the semicolon instead when i posted the message. :)
Any other suggestions?

Thanks.
Knut

if the webserver and the sql server are on the same machine, you don't need to specify the fullname of the server in the connection string; you can specify only "." (a single dot) like this:

"data source=.;initial catalog=felicitas_new;persist security info=False;user id=myId;password:myPass;packet size=4096"

the use of the dot instead of the server name, is, i think, a feature of the ole db client.

you can also replace the server name with "localhost" like this:

"data source=localhost;initial catalog=felicitas_new;persist security info=False;user id=myId;password:myPass;packet size=4096"

this is because (allmost) all computers using TCP/TP, have the "localhost" name asociated with the 127.0.0.1 ip address. (in the %windir%\system32\drivers\etc\hosts file).

instead of the dot or "localhost", you could also try using "127.0.0.1" (the loopback ip address).

maybe one of the above ways will work.

defiant.