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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-12 : 07:13:19
|
| Sameer writes "Hi,Could you please send me the code for the connection string to connect to SQL Server 2000 from ASP using :a.)providerb.)driver.Also, are the drivers / providers used to connect to SQL Server 2000 the same as those used to connect to SQL Server 7.0 ? Sameer" |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2003-02-12 : 11:16:18
|
| The same ones should still work, but newer ones are probably coming out all the time, with each ADO upgrade. However, they all use the same name between upgrades. So the same connection string should still work.The sql provider is SQLOLEDB. You don't need to specify driver, I think, from VB experience.Sarah Berger MCSD |
 |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2003-02-12 : 11:18:29
|
| Using a driver and a provider are mutually exclusive. For example, if you use Merants ODBC driver versus using the SQL OLEDB provider. Can you elaborate on your requirements? |
|
|
|
|
|
|
Connecting to SQL 2000