Re: Which is the best provider for SQL Server 2000 and VB6
From: Val Mazur (group51a_at_hotmail.com)
Date: 06/24/04
- Next message: Val Mazur: "Re: Access Help"
- Previous message: Val Mazur: "Re: ADO and Oracle PL/SQL Table"
- In reply to: Jon Blues: "Which is the best provider for SQL Server 2000 and VB6"
- Next in thread: Jon Blues: "Re: Which is the best provider for SQL Server 2000 and VB6"
- Reply: Jon Blues: "Re: Which is the best provider for SQL Server 2000 and VB6"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Val Mazur: "Re: Access Help"
- Previous message: Val Mazur: "Re: ADO and Oracle PL/SQL Table"
- In reply to: Jon Blues: "Which is the best provider for SQL Server 2000 and VB6"
- Next in thread: Jon Blues: "Re: Which is the best provider for SQL Server 2000 and VB6"
- Reply: Jon Blues: "Re: Which is the best provider for SQL Server 2000 and VB6"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
