Re: Which is the best provider for SQL Server 2000 and VB6

From: Val Mazur (group51a_at_hotmail.com)
Date: 06/24/04 

Date: Wed, 23 Jun 2004 22:04:36 -0400

Hi Jon,

OLEDB Provider for SQL Server is the best choice. First of all it is native.
Second - ADO does NOT work with ODBC driver directly and in a case if you
select ODBC driver, then ADO will place OLEDB for ODBC provider between the
ADO and ODBC driver. 

-- 
Val Mazur
Microsoft MVP
"Jon Blues" <Jon Blues@discussions.microsoft.com> wrote in message 
news:C00E23C9-923C-441D-8735-3C482A175482@microsoft.com...
> Can you tell me which is the best provider for performance when connecting 
> to SQL Server 2000 from VB6. There is a SQL Server driver available 
> through control panel but not in the configuration of an ADO control in 
> VB6, the only option is OLEDB for SQL Server. Am I missing something?
>
> Many Thanks in advance

Relevant Pages

  • Re: Mysterious OLE DB DBID propids
    ... > When I returned that to ADO, it didn't go over too well. ... > of a hierarchical return rowsets combined with a client cursor causes ... > ADO to make the decision that the "provider does not support this ... Books Online for SQL Server SP3 at ...
    (microsoft.public.data.oledb)
  • Re: Which is the best provider for SQL Server 2000 and VB6
    ... "Val Mazur" wrote: ... > OLEDB Provider for SQL Server is the best choice. ... > select ODBC driver, then ADO will place OLEDB for ODBC provider between the ...
    (microsoft.public.data.ado)
  • Re: Mysterious OLE DB DBID propids
    ... SQL Server doesn't known about ... When I returned that to ADO, it didn't go over too well. ... this is a provider that often returns hierarchical ... >> Could someone from Microsoft please tell me what DBID optional columns ...
    (microsoft.public.data.oledb)
  • Re: CREATE DATABASE fails in DBD::ADO 2.75-2.83
    ... > mySQL to SQL Server, and the SQL Server examples I had to work with all ... > could be more dynamic with ADO. ... - OLE DB Provider for ODBC Drivers ...
    (perl.dbi.users)
  • Re: ADO (ActiveX) data binding to .NET Windows Form controls
    ... ADO .NET is not oriented to SQL Server. ... with any compatible OLEDB provider. ... prevent you from using Jet or other standard OLEDB providers. ...
    (microsoft.public.dotnet.languages.vb)