Sunday, February 19, 2012

Connection string for SQL Server 2000

I am upgrading my SQL Server 6.5 to SQL Server 2000 and i am
using the following connection string to connect to my SQL Server 6.5
database.

Provider=sqloledb;Data Source=.;Initial Catalog=emu;User Id=sa;Password=""

Do i need to update the provider or any of these settings to connect to SQL Server 2000?Nope, just make sure, you got the latest MDAC (2.7 SP1a) version.|||Thanks DoktorBlue...

No comments:

Post a Comment