AndersWP
asked on
Using Access 97 without a BDE alias
In Delphi you can access a Paradox database without using a BDE alias by setting the database object property 'DriverName' to 'standard' and setting the current directory to the directory that contains the Paradox table files.
Is there a way of doing something similar with an Access 97 datbase, i.e. accessing it through the BDE driver but without using a BDE alias?
Thanks in advance,
AndersWP
Is there a way of doing something similar with an Access 97 datbase, i.e. accessing it through the BDE driver but without using a BDE alias?
Thanks in advance,
AndersWP
Why you don't want to use BDE Alias?
ASKER
Because I have to distribute my application to a large number of PC's, and I would prefer to have as little bother as possible with the BDE configuration.
AndersWP
AndersWP
I don't know the answer, but it takes 2 lines to add an alias to the BDE, here is an example for adding an Alias named 'Sample' for Informix:
Check(dbiInit(Nil));
Check((DbiAddAlias(Nil, 'Sample', 'INFORMIX', 'DATABASE NAME:SampleDB;' +
'SERVER NAME:ol_ronit;' + 'USER NAME:informix;', True)));
for Access you will have to set other parameters, see BDE docs.
Check(dbiInit(Nil));
Check((DbiAddAlias(Nil, 'Sample', 'INFORMIX', 'DATABASE NAME:SampleDB;' +
'SERVER NAME:ol_ronit;' + 'USER NAME:informix;', True)));
for Access you will have to set other parameters, see BDE docs.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Right on the button!
Thanks,
AndersWP
Thanks,
AndersWP
Invalid Alias Name error !