From: esquel@sommarskog.se   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)