Board index » delphi » ADO & Vista (aka Longhon)

2005-09-24 05:12:57 AM
delphi60
I have today tested a Delphi 5 app that uses the following connection
string to a SQL Server, and it fails if I use the ODBC Connection
dialog that comes with Vista I get a Provider of SQL Server rather than
Provider=SQLOLEDB.1 what is the correct value for Provider?
TIA
Graham Harris
--
 

Provider=SQLOLEDB.1 is for native OLEDB provider for MS SQL Server 2000 or
prior, Provider=SQLNCLI is OLEDB provider for MS SQL Server 2005. "SQL
Server" is name of ODBC driver for MS SQL Server 2000 and prior, "SQL Native
Client" - ODBC driver for MS SQL Server 2005.
I very recommend to use native OLEDB provider, not ODBC, with ADO and MS SQL
Server.
//------------------------------------------
Regards,
Vassiliev V. V.
www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Graham Harris" <XXXX@XXXXX.COM>???????/???????? ? ????????
?????????: news:43346fd9$XXXX@XXXXX.COM...

Viatcheslav V. Vassiliev writes:
Thanks
Graham