Subject | cannot attach to password database |
---|---|
Author | sgharp |
Post date | 2004-04-14T15:06:39Z |
Hi All,
I'm having trouble using the TIB_Script control to create a
database. When I try to execute I get the following errors.
*************************************************
Error Code: 335544653
Error Message:
ISC ERROR CODE:335544653
ISC ERROR MESSAGE:
cannot attach to password database
STATEMENT:
TIB_DSQL: "<TApplication>.DM.xmScript.<TIB_DSQL>."
Error Codes:
335544653
0
SQL Code: -902
SQL Message:
SQL ERROR CODE:-902
SQL ERROR MESSAGE:
Unsuccessful execution caused by a system error that
precludes
successful execution of subsequent statements
SQL:
create database 'C:\Data\Locations\XmWin\xData\XmWin.
Gdb'
User 'fred'
Password 'harry'
PAGE_SIZE = 4096
***************************************************
Code for using TIB_Script:
with XmScript do
Begin
Sql.Clear;
Sql.Add('SET SQL DIALECT 3;');
Sql.Add('create database ' + QuotedStr(FName));
Sql.Add(' User ' + QuotedStr(FUserName));
Sql.Add(' Password ' + QuotedStr(FPassword));
Sql.Add('PAGE_SIZE = ' + IntToStr(FPageSize) + ';');
Sql.Add('Commit;');
Execute;
End;
I've just started having this problem since upgrading to IBO v4x.
My code worked fine under previous versions however, I'm not
convinced the difference in versions is the issue.
Any ideas?
Steve
I'm having trouble using the TIB_Script control to create a
database. When I try to execute I get the following errors.
*************************************************
Error Code: 335544653
Error Message:
ISC ERROR CODE:335544653
ISC ERROR MESSAGE:
cannot attach to password database
STATEMENT:
TIB_DSQL: "<TApplication>.DM.xmScript.<TIB_DSQL>."
Error Codes:
335544653
0
SQL Code: -902
SQL Message:
SQL ERROR CODE:-902
SQL ERROR MESSAGE:
Unsuccessful execution caused by a system error that
precludes
successful execution of subsequent statements
SQL:
create database 'C:\Data\Locations\XmWin\xData\XmWin.
Gdb'
User 'fred'
Password 'harry'
PAGE_SIZE = 4096
***************************************************
Code for using TIB_Script:
with XmScript do
Begin
Sql.Clear;
Sql.Add('SET SQL DIALECT 3;');
Sql.Add('create database ' + QuotedStr(FName));
Sql.Add(' User ' + QuotedStr(FUserName));
Sql.Add(' Password ' + QuotedStr(FPassword));
Sql.Add('PAGE_SIZE = ' + IntToStr(FPageSize) + ';');
Sql.Add('Commit;');
Execute;
End;
I've just started having this problem since upgrading to IBO v4x.
My code worked fine under previous versions however, I'm not
convinced the difference in versions is the issue.
Any ideas?
Steve