Article View: borland.public.cppbuilder.database.ado
Article #1186Re: Newbie database question
From: Viatcheslav V. Vassiliev
Date: Tue, 26 Oct 2004 14:37
Date: Tue, 26 Oct 2004 14:37
37 lines
2400 bytes
2400 bytes
If you have BCB5 Ent or BCB6 you may connect with ADO. 1. Add TADOConnection. 2. Set ConnectionString to "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\test.mdb", change c:\test.mdb to real path. 3. Add TADOTable, set Connection to ADOConnection1, set CursorLocation = clUseServer and TableDirect = True and TableName = ... (place table name here). 4. Set TADOTable Active to True. 5. Add TDataSource and TDBGrid as usual and see results. //------------------------------------------ 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) "Mart" <marthijn@vuelta.tmfweb.nl> �������/�������� � �������� ���������: news:417e14e8$1@newsgroups.borland.com... > Hello, > > I am quite new to database programming so I have a question: > I did some programming on a paradox database using the BDE. > Now I want to use a access database. Someone told me that I > should use ODBC because this is on every machine so you don't > have to distibute BDE. > How do I connect an access database in my software using ODBC? > Which components mut I use? > Does this have anything to do with ADO? > > Thanks for your info in advance, > > Mart. > >
Technical Details
Message-ID:
<417e6119$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!diablo.voicenet.com!38.119.100.83.MISMATCH!news-out1.nntp.be!propagator2-sterling!news-in.nuthinbutnews.com!in.nntp.be!caladan.arrakis.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<417e14e8$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,f9840124c285ba83 X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com> Newsgroups: borland.public.cppbuilder.database.ado References: <417e14e8$1@newsgroups.borland.com> Subject: Re: Newbie database question Date: Tue, 26 Oct 2004 18:37:12 +0400 Lines: 39 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 NNTP-Posting-Host: 213.234.218.42 Message-ID: <417e6119$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1098801433 213.234.218.42 (26 Oct 2004 07:37:13 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!diablo.voicenet.com!38.119.100.83.MISMATCH!news-out1.nntp.be!propagator2-sterling!news-in.nuthinbutnews.com!in.nntp.be!caladan.arrakis.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail