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.
| Author |
Topic |
|
vk007
Starting Member
2 Posts |
 Posted - 2008-07-30 : 14:09:27
|
| 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 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-30 : 22:55:48
|
| Dup post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107733 |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-07-31 : 11:41:31
|
| Have you checked www.connectionstrings.com? I don't remember a driver called "SQL Server". Personally since you are using SQL 2005, I would use "Provider=SQLNCLI" instead of "Driver=SQL Server". |
|
|
|
|
|
|
Setting up global.asa for SQL server 2005