Good Morning All

I'm trying to create a simple connection string to a SQL 2000 server using
the old "SQL Server" driver - not the
Native Client, but it is not listed in my list of providers. I'm using
Windows 7 Ultimate. I have reinstalled MDAC 2.8 SP1 with no difference.
This is critical to me since I have clients who still connect with this
driver.

Does anyone know how to make it appear in the list?

Thank you

Matthew Wells
matthew.wells (AT) firstbyte (DOT) net

Matthew Wells (matthew.wells (AT) firstbyte (DOT) net) writes:
Provider=SQLOLEDB;Data Source=... etc

Don't really know what you mean with "list of providers", but maybe you
are using a GUI. It would not be the first time that hampers productivity.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Matthew Wells wrote:
You must mean the ODBC driver ...

Perfectly understandable when you realize it's not a provider.

You have to use the "Provider for ODBC databases" (MSDASQL) to use an ODBC
driver. Go to Connectionctrings.com for further details.