Re: Which is the best provider for SQL Server 2000 and VB6
From: Jon Blues (JonBlues_at_discussions.microsoft.com)
Date: 06/24/04
- Next message: Microsoft: "Insert to Access DB with Autonumber field"
- Previous message: Wesam: "Re: How to detect available SQL Servers in C#?"
- In reply to: Val Mazur: "Re: Which is the best provider for SQL Server 2000 and VB6"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Jun 2004 05:46:01 -0700
Val Excellent, as always!!
Many Thanks
Jon
"Val Mazur" wrote:
> 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: Microsoft: "Insert to Access DB with Autonumber field"
- Previous message: Wesam: "Re: How to detect available SQL Servers in C#?"
- In reply to: Val Mazur: "Re: Which is the best provider for SQL Server 2000 and VB6"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
