SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 ASP connection string for SQL 2005
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

SamC
White Water Yakist

USA
3459 Posts

Posted - 03/14/2006 :  19:24:18  Show Profile
Is there any change needed in the ASP connection string when moving from 2000 to SQL 2005?

tkizer
Almighty SQL Goddess

USA
35934 Posts

Posted - 03/14/2006 :  19:30:54  Show Profile  Visit tkizer's Homepage
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 Kizer
aka tduggan
Go to Top of Page

SamC
White Water Yakist

USA
3459 Posts

Posted - 03/14/2006 :  22:05:21  Show Profile
Hmmm... found it...

I had server=(local) for SQL 2000

changed it to

server=SQL2005 which didn't work

but

server=localhost\SQL2005 seems to work fine.
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 03/15/2006 :  06:51:45  Show Profile
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"
Go to Top of Page

SamC
White Water Yakist

USA
3459 Posts

Posted - 03/15/2006 :  07:22:04  Show Profile
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.
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 03/15/2006 :  07:36:08  Show Profile
Great

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000