Page 1 of 1

Again and again: Your user name and password are not defined

Posted: Tue 17 Apr 2012 11:18
by GVCL
Hello,

D2009
IBDAC 4.1.3
Firebird 1.5 and 2.1

It happens every now and then and I can not see why:

Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

I get this message and whatever I do I can not access the database using IBDAC. Not problems using BDE, IB or i.e. IBOConsole - but with TIBCConnection I get this problem.

What could be the reason? (and be sure the user and password are defined...it is sysdba and masterkey)

Kind regards

Posted: Tue 17 Apr 2012 12:48
by ZEuS
Hello!

Unfortunately, we cannot reproduce this problem.
Can you reproduce the error in the IbDacDemo project that is supplied with IbDAC?
The IbDacDemo project is located in the IbDAC_Demos_Directory\IbDacDemo directory.
Try to connect to your database in the ConnectDialog branch of the IbDacDemo.

Posted: Tue 17 Apr 2012 14:01
by GVCL
Hello,

the demo works - but I found a funny thing:

When I copy the TIBCConnection from the demo to my datamodule and try to connect to the database it works - when I use the connection which is on the form since I build it, it does not work (I get the mentioned error message).

Then what I found is: when in Params i.e
user_name=SYSDBA
password=masterkey
lc_ctype=ISO8859_1
is stored then the connection does not work. When I delete this - I can connect.

Kind regards

Posted: Wed 18 Apr 2012 08:45
by ZEuS
Hello.

Yes, the problem occurs due to duplicating of the username and password values, that you set for TIBCConnection.
TIBCConnection has its own Username and Password properties, so you don't need to set them using the Params property, unlike you do in the InterBase components.
To resolve this problem, reset the values of the Username and Password properties or remove the "user_name=..." and "password=..." values from the Params list.