From: Frederic H. <nos...@be...> - 2005-12-22 21:59:10
|
Vladimir, About the first issue, sorry that was a typo, I specified ib_udf twice. fbembed.dll is located, with all other necessary files, under c:\windows\system32 inullif UDF function is defined in FBUDF, and script has been run on my DB. when i perform "select inullif(1,2) from rdb$database;" in my ODBC client app : I get two error messages : 1. "Cette application n'a pas pu démarrer car fbclient.dll est introuvable. la réinstallation de cette application peut corriger ce problèm". (message is displayed in frensh becuase I have a french WinXP, translated in english: the application could not be started because fbclient.dll cannot be found. Reinstalling the application could solve this problem 2. SQLState HY000 invalid request BLR at offset 60 function INULLIF is not defined module name or entrypoint could not be found When I run the query "select bin_and(1,2) from rdb$database;" then I don't have any errors. bin_and is defined in ib_udf, and script has been run on my DB. Why do UDF functions in FBUDF produce errors, and functions in IB_UDF run fine when using FBEMBED.DLL ? Solution : When I rename fbembed.dll to fbclient.dll, and configure ODBC to use the renamed fbclient, then the inullif function runs without any problem. Kind regards, Frederic Hoornaert ""Vladimir Tsvigun"" <pr...@hm...> a écrit dans le message de news: dodrfa$421$1...@ne...... > Hi Frederic, > >> 1) I have ran the SQL Scripts fbudf.sql and ib_udf.sql to add the > functions >> to my database. >> I can use the functions from ib_udf within my ODBC application, but when >> I >> run a function located in ib_udf, it doesn't work.In EMS > InterBase/FireBird >> Manager, I get error message that fbclient.dll cannot be found. > > Please, specify : > in ib_udf or in fbudf > >> 2) As explained before, my intention is to use several applications which >> use the same ODBC source with the embedded server. >> With your help (FIREBIRD environment variable) I got the application >> connected to the DB. >> However, when I try to connect with the second application, while the > first >> is allready connected, I get the error "SQLSTATE 08004 I/O error for >> file, >> error while trying to open file" > > Yes, it's right! > Your App -> Odbc32.dll -> OdbcJdbc.dll(->IscDbc.dll) -> FbEmbed.Dll ==> > this one indivisible whole > >> Can FBEMBED.DLL not be used for multiple connections ? > > It is impossible > > -- > Best regards, > Vladimir Tsvigun > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log > files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > |