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.

If anyone remembers using SQL 2000 and creating a .udl file, you'll remember
that when the list of providers came up, the "SQL Server" was there. This
would be the same whether using a gui or building the string manually. It's
the provider that's needed. How I make the connection is irrelevant.

Does anyone know how to make the provider "SQL Server" appear in the list?

Thank you

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

I answered this the first time you posted it. Did you not see my reply? Or
was my reply not helpful?

Just in case, here it is again:

Bob Barrows wrote:
Maybe you could clarify what "list" you are trying to see this driver in. An
ODBC driver will not appear in a list of OLE DB providers.

Thanks for the effort, but this does not help me. I'm not looking for and
ODBC connection. The closest I've seen is Provider=SQLOLEDB.1.

I need to pick "SQL Server" from the list of providers. How do I get that
in the list?


"Bob Barrows" wrote in message news:j62a1s$i4k$1 (AT) dont-email (DOT) me...


I answered this the first time you posted it. Did you not see my reply? Or
was my reply not helpful?

Just in case, here it is again:

Bob Barrows wrote:
Maybe you could clarify what "list" you are trying to see this driver in. An
ODBC driver will not appear in a list of OLE DB providers.

Matthew Wells (matthew.wells (AT) firstbyte (DOT) net) writes:
Like Bob, I seem to recall that I answered to your original post.

Anyway, to use the old ODBC driver for SQL Server, specify

Driver={SQL Server}

To use the old OLE DB provider for SQL Server, specify

Driver=SQLOLEDB

These are the two choices. Nevermind what you see in a list, it's a
connection string you want in the end, isn't it?
--
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