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

GVCL · Post by **GVCL** » Tue 17 Apr 2012 11:18

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

ZEuS · Post by **ZEuS** » Tue 17 Apr 2012 12:48

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.

GVCL · Post by **GVCL** » Tue 17 Apr 2012 14:01

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

ZEuS · Post by **ZEuS** » Wed 18 Apr 2012 08:45

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.