On 07/07/13 20:57, Thomas Beckmann wrote:
>>>> I'd like to select from a FB2.5-DB with FB3.0 and get the error
>>>> "username and password are not defined" (they sure are, I can run the
>>>> statement from another FB2.5-database), and I assume, the problem is the
>>>> encrypted password.
>>>>
>>>> Is there a parameter for "execute statement" to tell that "Legacy_Auth"
>>>> plugin is to be used?
>>>       FB3 acts as a client for FB25 in your case. So, AuthClient should 
>>> contain
>>> Legacy_Auth plugin.
>> Contains it by default
> Hm, but if I omit it, it does not work, if I add it, it works...
>
>>> Probably, it should be the first plugin in the list...
>> Not necessary
> Hm, I made a couple of tests and it seems to make a difference...
>

This is the default FB3 configuration. I do:

# ./isql -user sysdba -pas masterkey localhost:employee
Database:  localhost:employee, User: sysdba
SQL> set term ^;
SQL> execute block returns(x char(80)) as begin execute statement 
'select CURRENCY from country where country like ''Italy''' into :x; 
suspend; end^

X
=============================================================================== 

Euro

SQL> execute block returns(x char(80)) as begin execute statement 
'select CURRENCY from country where country like ''Italy''' on external 
'localhost/3051:employee' as user 'sysdba' password 'masterkey' into :x; 
suspend; end^

X
=============================================================================== 

Lira

SQL>

I.e. it works for me in default configuration.
Please provide full test case to reproduce your error.


------------------------------------------------------------------------------
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to