Re: ADO & Vista (aka Longhon)

Viatcheslav V. Vassiliev wrote:

Thanks

Graham

> 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)
>
.

Relevant Pages

  • Re: Strange error code for deadlock
    ... Since you are working through OLEDB provider, ... > I am currently writing an deadlock handler for our application (a COM ... > Having searched both ADO and SQL Server references, ... > error message to find "deadlock victim" for example); ...
    (microsoft.public.vb.database.ado)
  • Re: parameter names in Sql Server
    ... If you stick to the OLEDB provider you can use ... > query that can be used with both SQL Server and Oracle. ... > executed to make any necessary changes. ... >> character or something like this... ...
    (microsoft.public.data.ado)
  • Re: OLAP Linked query - 8k limit
    ... I checked the MSOLAP properties & the 'In Process' option is enabled. ... communicate with SQL Server using memory segement. ... OUT of process an OLEDB provider is loaded outside the SQL Server process ... and communicate with SQL using RPC with some limitations... ...
    (microsoft.public.sqlserver.olap)
  • Re: OLEDB: Interface ICOmmandPersist not Available
    ... For stored procedures you may use ODBC syntax: ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... >> Acsess) OLEDB provider. ... >> Vassiliev V. V. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: C# Windows Service Problem
    ... Note that connecting to SQL server and using DSO are ... I don't use an OLEDB provider anywhere in the program.. ... The error message refers to the OLEDB provider for DSO, ...
    (microsoft.public.dotnet.languages.csharp)