Re: ADO & Vista (aka Longhon)

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.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Graham Harris" <ng@xxxxxxxxxxxxxxxxxxxxxxxx> ???????/???????? ? ????????
?????????: news:43346fd9$1@xxxxxxxxxxxxxxxxxxxxxxxxx
>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
> --
>


.

Relevant Pages

  • Re: SQL Losing Data
    ... the other problem wasn't a SQL Server thing. ... And I would argue that it was an ODBC driver issue, solely, not even Access. ... sidebar shows a pencil, indicating that edits are being performed. ... I've tried using Profiler in the past and found it a bit unwieldy. ...
    (microsoft.public.sqlserver.odbc)
  • Re: SQL Server 2005 "Left outer join" return nothing through ODBC call
    ... Some outer joins suddenly returned empty resultsets on SqlServer 2005 in 2000-compatibility-mode, but only within our application. ... The same query executed in Query Analyzer just worked fine. ... We finally solved that issue by upgrading to the latest SqlServer ODBC driver which can be found at: ... It did work for SQL Server 7.0 and SQL server 2000. ...
    (microsoft.public.sqlserver.odbc)
  • Re: localized ODBC driver datetime issue
    ... which I use to connect to MS SQL Server 2003. ... SS> format, because this format does not correspond to the Russian date ... SS> was a way to know the language used by the ODBC driver, ...
    (microsoft.public.data.odbc)
  • Re: Ole db provider for an odbc data source
    ... We now wish to wrap this odbc driver to be able to provide an ole db ... That is an OLE DB provider that comes with ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.data.oledb)
  • ADO & Vista (aka Longhon)
    ... string to a SQL Server, and it fails if I use the ODBC Connection ... Provider=SQLOLEDB.1 what is the correct value for Provider? ...
    (borland.public.delphi.database.ado)