localhost

[masterlodi]

I am trying to access an SQL server on my local machine from IIS but the script can never find the server, what is wrong?

connstr = "DRIVER={SQL Server};SERVER=127.0.0.1;UID=dbuser;PWD=dbpasswd;DATABASE=Northwind;

 

[vongrunt]

Try (local) instead of loopback IP address. What happens?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[mrdenny]

You can also try putting in the machine name.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[masterlodi]

I used this as suggested

connstr = "DRIVER={SQL Server};SERVER=(local);UID=dbuser;PWD=dbpasswd;DATABASE=Northwind;"

and all works brilliantly!

Thank you !!!!!