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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2006-03-14 : 19:24:18
|
| Is there any change needed in the ASP connection string when moving from 2000 to SQL 2005? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-14 : 19:30:54
|
| The connection string is dependent on your driver and not on the database server. So if you are using the same driver, then you don't need to change anything. I'm not sure if there is an updated driver for 2005.Tara Kizeraka tduggan |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2006-03-14 : 22:05:21
|
| Hmmm... found it...I had server=(local) for SQL 2000changed it to server=SQL2005 which didn't workbutserver=localhost\SQL2005 seems to work fine. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-03-15 : 06:51:45
|
| Is "SQL2005" the name of your instance? Do you have both 2000 and 2005 on the same server? I just installed the dev-edition last night on my laptop on which I have 2000 from before and I just named my new instance "SQL2" so I wondered if I had to use the same connstring as you.--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2006-03-15 : 07:22:04
|
quote:
Originally posted by Lumbago
Is "SQL2005" the name of your instance? Do you have both 2000 and 2005 on the same server?
Yes and Yes. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-03-15 : 07:36:08
|
Great  --Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
|
|
ASP connection string for SQL 2005