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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 CONNECTING TO SQL SERVER 2000

Author  Topic 

sameerv
Starting Member

29 Posts

Posted - 2003-02-10 : 05:03:31
Hi,
The provider for connecting to SQL Server 7.0 is sqloledb.
Will this provider with the same version be used to connect to SQL Server 2000 ?

Also, can you give me a sample connection string to connect to SQL Server 2000 from ASP.


Thanx.

Cursors - A curse

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-02-10 : 06:46:23
Hi

It's the same connection string.

I.E.


Provider=SQLOLEDB; Data Source=MyServerName; User ID=MyUser; Password=MyPassword



Damian
Go to Top of Page
   

- Advertisement -