How to connect to SQL Server 2000 and SQL Server 2005 in one computer??

Hi All!!!

In my Computer has MS SQL Server 2000(with default Instance) and now I Install MS SQL server 2005(with Instance name: SQL2005 ). Now I want to write Web Application to connect to the both databases (SQL Server 2000 and MS SQL Server 2005), How to Add connection string in my web.config to do it.

Help me ?

Thanks & Regards,

You can put the two connection strings in the web.config file and use either in your code..

|||

Hi !!!

Thanks for your support !!! Please give me the connection string to connect to SQL Server 2000 & SQL Server 2005.

Thanks

|||

check out www.connectionstrings.com