Article View: borland.public.cppbuilder.database.ado
Article #488Re: To use ODBC or ADO?
From: Foo Tze Wan
Date: Thu, 18 Aug 2005 01:49
Date: Thu, 18 Aug 2005 01:49
24 lines
2160 bytes
2160 bytes
Thanks, Arnie for your reply. >It's more like "ADO over ODBC", and yes, you can do it, though >most will recommend against it. MS provides an OLEDB driver for >"generic ODBC". It can be used with Borland's ADO. You'd >probably be better off using the OLEDB provider supplied by the >manufacturer if you support other DBs. The reason why I thought my application should retain ODBC connectivity to databases is because these databases are ODBC compliant only, but not OLEDB. (Perhaps, I have not been in tune with newer data access technologies.) The databases we envision we will be using are Oracle and SQLServer. After some brief searces on the web, I think they should also support OLEDB. >If you go with ADO, you'll have to do sime fiddling with the >query or dataset properties in order to get good performance. >These include cursor location and type as well as locking mode >and cache size. I will try with ADO, and when these issues arise, will grapple with them. I hope help from here and the web can be easily found then. Thanks again, Tze Wan
Technical Details
Message-ID:
<4303e931@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!border2.nntp.ams.giganews.com!nntp.giganews.com!border1.nntp.ams.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<4302e629@newsgroups.borland.com> <43036726@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,814166c1bc0fe9b5 X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII-7-bit Reply-To: "Foo Tze Wan" <twfoo@nospam.com> From: "Foo Tze Wan" <twfoo@nospam.com> Newsgroups: borland.public.cppbuilder.database.ado References: <4302e629@newsgroups.borland.com> <43036726@newsgroups.borland.com> Subject: Re: To use ODBC or ADO? Date: Thu, 18 Aug 2005 09:49:42 +0800 Lines: 26 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 NNTP-Posting-Host: 210.24.189.100 Message-ID: <4303e931@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1124329777 210.24.189.100 (17 Aug 2005 18:49:37 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!border2.nntp.ams.giganews.com!nntp.giganews.com!border1.nntp.ams.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail