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
