Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Setting up global.asa for SQL server 2005

Author  Topic  vk007 Starting Member 2 Posts Posted - 2008-07-30 : 14:00:55 I have my IIS server and SQL server 2005 running on separate machines. I am using classic ASP. My global.asa connection string is not able to recognize the SQL server 2005 database. I think my syntax is wrong. I have both SQL 2000 and SQL 2005 servers running on the same machine. My global.asa connection string connects fine with a SQL 2000 database but does not connect with SQL 2005 database. Here is the string for SQL 2000 that works fine: DRIVER=SQL Server;SERVER=IPaddress;UID=usertest;WSID=IIS;DATABASE=testDB;QueryLogFile=Yes; Can somebody tell me the syntax for the connection string ( in global.asa )for SQL server 2005? Thanks in advance