Re:How can I access password protected paradox table?
"Rock" <evilhun...@lycos.co.uk> ha scritto nel messaggio
news:3e649d5d@newsgroups.borland.com...
Quote
> Hi
> I use password protected paradox table by TQuery and connect directly
to
> the table (set database file path to DatabaseName field) -->
> Query1.DatabaseName := 'C:\Database';
> code
> ====
> var
> db: TDatabase;
> begin
> db := TDatabase.Create(Self);
> db.DatabaseName := 'D:\Delphi';
> db.LoginPrompt := False;
> // db.Params.Values['user name'] := ''; // paradox table has no user
> name
> db.Params.Values['password'] := 'mypassword';
> Query1.DatabaseName := db.DatabaseName;
> Query1.SQL.Add('select * from Test');
> Query1.Open;
> // *********** It does not work *************
> There's an exception error with message "Insufficient table rights for
> operation. Password required. Table: D:\Delphi\Test.db.".
> Regards
> Rock
It seems that you're using TDatabase incorrectly:
try this:
var
db: TDatabase;
begin
db := TDatabase.Create(Self);
db.DatabaseName := 'D:\Delphi';
db.AliasName := 'MyAlias';
db.LoginPrompt := False;
// db.Params.Values['user name'] := ''; // paradox table has no user
name
db.Params.Values['password'] := 'mypassword';
Query1.DatabaseName := 'MyAlias';
Query1.SQL.Add('select * from Test');
Query1.Open;
Ferruccio
