ASP.NET Forum

**Hutch** · 09-20-2005, 05:14 PM

I am running SQL 2000 server, and IIS and can not get the two to talk. I dont recieve an application error so have to assume that the database is not even being reached. Using ASP script is there any connection that has to be made outside of the ASP script? Or a program that needs to be loaded on the server? Any help is appreciated.

**chrishirst** · 09-20-2005, 05:21 PM

What code are you using to connect?

DSN or connection string ?

**Hutch** · 09-20-2005, 05:34 PM

Connection string
set dcnDB = Server.CreateObject("adodb.connection")
dcnDB.open "Provider=SQLOLEDB;DATA SOURCE=comp name;DATABASE=dbase name;uid=webuser;password=webuser"

**chrishirst** · 09-20-2005, 05:48 PM

pwd=password NOT password=password