How to use MSAccess?

Thread View: borland.public.cppbuilder.database.ado

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by David Kallesen Thu, 29 Mar 2001 20:41

#5570

Author: David Kallesen
Date: Thu, 29 Mar 2001 20:41

20 lines
1381 bytes

Hi

I have a "c:\test.mdb" with a table called test_table and to rows (id=p.key
and test).

Please help me with a sample on:
    connect to mdb file
    insert record in test_table
    select record from test_table
    delete record in test_table
    close mdb file

I use BCB5Pro and I don't have ADO components.
I think I should use OLEDB. But I don't have any experince in this. And I
can't find any usefuld i n Builder's help, MSDN or MSSDK.

So please help......

Regards
David Kallesen.

Re: How to use MSAccess?

#5576

Author: Mark Cashman
Date: Sat, 31 Mar 2001 00:44

21 lines
1570 bytes

Hi, David!

You should be able to use an Access database without the ADO components.
The BDE supports it with a native driver or through ODBC.

Have a look at

http://www.temporaldoorway.com/programming/cbuilder/basics/simpledbprogram.htm

for an example of a standard BDE database program. All you need to do is
use an alias that points to your Access database, and the same program
should work fine with it.

------
Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at
http://www.temporaldoorway.com
- Original digital art, writing, music and more -
C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring
(Join us!)
http://www.temporaldoorway.com/programming/index.htm
------

Re: How to use MSAccess?

#5560

Author: Thomas Blankschein
Date: Sun, 15 Apr 2001 23:45

13 lines
1657 bytes

Hi David!

> I use BCB5Pro and I don't have ADO components.

The BDE comes with your BCB5Pro, it includes a native MS Access Driver.
Instead, have a look at www.islamov.com. The Diamond Access and Diamond ADO
components work fine for me. I�ve checked them with *.mdb-files under Win2k.
The nice thing about the ADO-components is, that you can easily use another
database (e.g. Oracle) without changing all your code. I haven�t tried this
(yet). Both components are shareware, the demo ist fully functional with a
small info box after closing the program.

Thomas

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads