ODBC
In order to access an *.gdb (or *.fdb) file,
KADaoDatabase1.UserName | sysdba |
KADaoDatabase1.Password | masterkey |
KADaoDatabase1.DatabaseType | ODBC |
KADaoDatabase1.Database | Select from the list of ODBC or BDE database aliases. (I am assuming that your system has at least one defined.) Setting this clears Database1.DatabaseName. |
KADaoDatabase1.DatabaseName | This is the name that TTable components will link to. This can be the same as Database1.AliasName, you may make up a name, or you may enter the fully qualified path to a Paradox database (directory). An MS Access mdb file can not be entered here. |
KADaoDatabase1.LoginPrompt | Set this False to disable the default dialog box. |
KADaoDatabase1.OnLogin | Attaching code to this event will also disable the default dialog box. (Hardcoding userID's and passwords is considered to be a security problem.) |
Using the Interbase Components
IBDatabase1.DatabaseName | Set this to the *.gdb or *.fdb file |
IBDatabase1.Connected | Set to true |
IBTransaction1.DefaultDatabase | Set to IBDatabase1 |
IBTransaction1.DefaultAction | Set to TACommit |
IBTransaction1.Active | Set to true |
IBTable1.Database | Set to IBDatabase1 |
IBTable1.Transaction | Set to IBTransaction1 |
IBTable1.TableName | Select a table from the list. |
IBTable1.Active | Set to true |
DataSource1.DataSet | Set to IBTable1 |
DBGrid1.DataSource | Set to DataSource1 |
Circular datalinks are not allowed.Instead of IBTable, you can use IBDataSet and set SelectSQL to
select * from CUSTOMEROr you can use IBClientDataSet and set CommandText to the query.
dbExpress
(dbExpress is available with
The first problem is that dbExpress produces a link to a "unidirectional"
database - this causes the DataGrid to not work.
The solution with
It turns out that
It was also not clear from the documentation how to configure the TClientDataSet. The solution is to set xx to one of these - table, query, storedProc - and to set xx to an appropriate value.
Well, I eventually got this to work. Then I tried to get the *.exe
to run on a machine that did not have
dbexpint.dll DBExpINT.dcu midas.dll
Notice - Delphi 6 does not require the xxx component.
That means that code written for