Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #657 > unrolled thread
| Started by | "Matthew Wells" <matthew.wells@firstbyte.net> |
|---|---|
| First post | 2011-09-09 08:56 -0400 |
| Last post | 2011-09-12 06:04 -0400 |
| Articles | 3 — 3 participants |
Back to article view | Back to comp.databases.ms-sqlserver
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
| From | "Matthew Wells" <matthew.wells@firstbyte.net> |
|---|---|
| Date | 2011-09-09 08:56 -0400 |
| Subject | Provider not listed... |
| Message-ID | <p2oaq.10980$OO1.5896@newsfe02.iad> |
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@firstbyte.net
[toc] | [next] | [standalone]
| From | Erland Sommarskog <esquel@sommarskog.se> |
|---|---|
| Date | 2011-09-11 23:17 +0200 |
| Message-ID | <Xns9F5DECFFD5933Yazorman@127.0.0.1> |
| In reply to | #657 |
Matthew Wells (matthew.wells@firstbyte.net) writes: > 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. 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@sommarskog.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
[toc] | [prev] | [next] | [standalone]
| From | "Bob Barrows" <reb01501@NOSPAMyahoo.com> |
|---|---|
| Date | 2011-09-12 06:04 -0400 |
| Message-ID | <j4klbi$746$1@dont-email.me> |
| In reply to | #657 |
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.
[toc] | [prev] | [standalone]
Back to top | Article view | comp.databases.ms-sqlserver
csiph-web