Databases - Delphi/KADao Problems

Delphi/KADao Problems

Active | Insert Queries | Database Locations

Making a table "Active"

Theoretically, these 3 lines should accomplish the same thing ... they don't.

SamplesDataModule.KADaoTable_Experiment_Details.Open;           // works
SamplesDataModule.Experiment_DataSource.DataSet.Open;           // fails
SamplesDataModule.Experiment_DataSource.DataSet.Active := true; // fails

Insert Queries

When an Insert query is used, the Find_First method will not find the new data unless the database is closed and re-opened.

Aliases_tbl.Active := false;
Aliases_tbl.Active := true;

I was not able to find another way to accomplish this.

Database Locations

With Delphi programs (*.exe's), *.mdb files can be anywhere that the developer has access. However, with web servers (CGI *.exe or ISAPI *.dll files), *.mdb files must be located on the same machine. For example

Samples=C:\Inetpub\wwwroot\rlc\SLP_DB\SamplePrep\Samples.mdb         works
Samples=Samples.mdb                                                  works
Samples=\\Enterprise\F\NIST\Main Database\Jet databases\Samples.mdb  fails

I assume that this is some type of access control issue where IIS does not have permission to access paths over the local network.

Author: Robert Clemenzi - clemenzi@cpcug.org

Delphi/KADao Problems

Making a table "Active"

Insert Queries

Database Locations

URL: http:// cpcug.org / user / clemenzi / technical / Databases / Delphi / KADao / Problems.html