Hi All!
In my computer I have Installed MS SQL Server 2005(Default Instance) & MS SQL Server 2000(Duynnh Instance). When I write an ASP.NET app to connect to SQL Server 2005 it's OK but not connect in SQL Server 2000. Please give me the SQL Connection string to connect to SQL Server 2000.
When I open Query analyzer connection is OK for both.
Thanks.
This is an awesome site i use to get connection string formats
http://www.connectionstrings.com/
Another easy way to get connection strings is to drag and drop and data adapter or a table from a database in server explorer, and look at the connection string it builds.
|||I think sql2000 and sql2005 use the same kind of connection string--both use the same sql server provider. You only need to check if you have specified the correct instance name, default database, login account/psw (if you use sql authentication mode) in your sql2000 connection string.
Hope my suggestion helps
No comments:
Post a Comment