In earlier posts I asked for help as FreeUDFLib.dll was not working in my FB 3
installation. fbvlad gave me the answer "it requires gds32.dll" but I
misunderstood his reply. I am using date and time functions in FreeUDFLib.
Looking at FreeUDFLib.dll in DependencyWalker shows it calls
Thanks Vlad for the suggestion. The file c:\windows\system32\msvcr100.dll is
already present. Does freeUDFLib.dll need gds32.dll? I am using freeUDFLib.dll
with several DB files and explicitly tell the connection software to use
fbclient.dll. I do have gds32.dll on the client PC. In testing
Thanks Vlad. I am failing with fb3 rc2 3.0.0.32366. Yours is?
I will re-install and try again tomorrow.
By experiments mentioned in this thread, UDF dlls that worked in FB 1 and 2 and
not able to be used in FB 3 RC2.I am using 32 bit files.
DLLs working in FB2.x can be placed in the FB3RC3 UDF folder and installed.
"extractyear" is in rfunc.dll, used OK in FB2.x.
When used in a FB3RC2 test,
If we dismiss rfunc.dll because it has bugs then I mention ib_udf.dll (the one
with FB2.x) and freeUDFLib.dll (that works under FB2.x). Both dlls install into
fb3rc2. Both fail in the manner I described. So what is the problem? Better yet
what are solutions?
ib_udf.dll (the one with fb3rc2)
Assuming this is an error in FB3 RC2, should I register it as an error? If so
where?
Ah, I did not know that Karol. I'll try this after the UDF problem has been
solved. Russell
Thank you Dimitry for the hint. Using DatabaseWorkbench I instruct the server
in which FB3 is installed to use fbclient.dll that comes with FB3. So I am
using the this fbClient.dll with all databases I am testing with FB3.
The freeUDFLib.dll file is working fine with FB2.5.x on another
Thanks for suggestions Karol. I am using Win 10 (64) and FB3 (32).
All DLLs are 32 bit, assessed by looking in the DLL files.
Russell
Added: Recap: Adding UDFs to databases in FB 3.0 RC2 is giving an error when
using any function in the added UDF. The UDFs packaged with FB3 are OK.
To the EMPLOYEE db packaged with FB3.0 RC2 I can add UDF fbudf.dll, which is
packaged with FB3 and its functions select values OK. I have also
I have a FB 2.5.5 database which I have migrated to FB3 RC2. I use the older
FreeUDFLib.dll. All the procedures of this DLL are in the database reported by
Database Workbench 5. The restore log for the migration shows no errors. This
DLL is in the FB 3 UDF folder. When running a stored
Is FB 3.x much faster than FB 2.5.x? I'm looking for some timing and stability
comparisons.
Thanks.
Perhaps my problem is in an incorrect installation setting?
I have FB 2.5.3 on a laptop. Win 7 32 bit.
I introduced a stored procedure and in it call F_LEFT(:varName, 24) to
truncate :varName from a vc(48).
This DB is used in Win 7 and win 8.1 else where without problem.
When I run the
Thank you Set, Mark and Maya. I think I see my error and will test it tomorrow.
On the network where F_LEFT worked I had installed FreeUDFLib.DLL long ago.
On the remote laptop where if failed I did not install FreeUDFLib.dll
Using Substring(..) or LEFT(..) is better as they require no
Problem and solution confirmed. Thanks to all helpers.
15 matches
Mail list logo