Groups > comp.databases.ms-sqlserver > #661

Re: Provider not listed...

From	"Bob Barrows" <reb01501@NOSPAMyahoo.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Provider not listed...
Date	2011-09-12 06:04 -0400
Organization	A noiseless patient Spider
Message-ID	<j4klbi$746$1@dont-email.me> (permalink)
References	<p2oaq.10980$OO1.5896@newsfe02.iad>

Show all headers | View raw

Matthew Wells wrote:
> Good Morning All
>
> I'm trying to create a simple connection string to a SQL 2000 server
> using the old "SQL Server" driver -

You must mean the ODBC driver ...

> not the
> Native Client, but it is not listed in my list of providers.

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

>  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?
>

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Provider not listed... "Matthew Wells" <matthew.wells@firstbyte.net> - 2011-09-09 08:56 -0400
  Re: Provider not listed... Erland Sommarskog <esquel@sommarskog.se> - 2011-09-11 23:17 +0200
  Re: Provider not listed... "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-09-12 06:04 -0400

csiph-web