How to register a DB in BDE and ODBC from Delphi

[Alexsey]

Hello to everybody!
Please help to a novicer in Delphi, how can i register my database (*.mdb - Access 97 file) in BDE and ODBC from Delphi to create a pseudonym. Thank you!

PS: Sorry for my English.

 

[svanels]

With Access 97 I like to use the native MSACCESS driver that comes with Delphi, but for Access 2000 it is better to use the ODBC connection.

Using the native msaccess driver:

1) Open the BDE administrator
2) Select Object --> New --> MSACCESS
3) At database name fill in the name and location of your database.


Using ODBC

1) Open the ODBC Data Source Administrator in the Control Panel
2) Go to System DSN --> add --> Microsoft Access Driver (*.mdb)
3) Fill in the name, location etc.
4) Open the BDE administrator
5) Select Object --> New --> Microsoft Access Driver (*.mdb)
6) At ODBC DSN select the database as defined in step 3



Regards Steven van Els
SAvanEls@cq-link.sr

 

[Alexsey]

It works! Big thanks ))