Article View: borland.public.cppbuilder.database.ado
Article #967Re: Connecting to a MS SQL db
From: Viatcheslav V. Vassiliev
Date: Fri, 18 Feb 2005 13:00
Date: Fri, 18 Feb 2005 13:00
25 lines
1905 bytes
1905 bytes
MS OLEDB Provider for SQL Server is specially designed for MS SQL Server, MS OLEDB provider fro ODBC is a wrapper for ODBC, i.e. it connects to ODBC driver and ODBC drivers works with MS SQL Server. MS OLEDB provider for SQL Server has more features and better works with 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) "bmkiss" <bmkiss67@cablespeed.com> �������/�������� � �������� ���������: news:4214c419@newsgroups.borland.com... > When setting up the ADOConnection to connect to a MS SQL db is it better > to > set the the Provider to Microsoft OLE DB Provider for SQL Server or > Microsoft OLE DB Provider for ODBC Drivers? What would the real > difference > be? > > Thanks > >
Technical Details
Message-ID:
<4215e6e9$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<4214c419@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,2a0be9f35098b618 X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com> Newsgroups: borland.public.cppbuilder.database.ado References: <4214c419@newsgroups.borland.com> Subject: Re: Connecting to a MS SQL db Date: Fri, 18 Feb 2005 16:00:26 +0300 Lines: 27 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-RFC2646: Format=Flowed; Original NNTP-Posting-Host: 85.93.137.199 Message-ID: <4215e6e9$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1108731625 85.93.137.199 (18 Feb 2005 05:00:25 -0800) Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail