Which is the SQL Provider for ADO?

[Cicada]

Which is the SQL Provider for ADO?
Jet or ODBC or OLE DB or ADO iteself???

 

[Terry Kreft]

SQLOLEDB is the native provider.

 

[Brendan Reynolds]

I'm assuming that by SQL you mean Microsoft SQL Server? If so, you can use
the ODBC provider, but there are better options for recent versions of SQL
Server. For SQL Server 2000 you can use the OLE DB Provider for SQL Server
("Provider=SQLOLEDB.1"). I think this also worked with the version prior to
SQL Server 2000, but that's from memory. For SQL Server 2005, you can use
the SQL Server Native Client provider ("Provider=SQLNCLI.1").