Subject | FB after Win7 upgrade and FB 2.1.3 to 2.5.0 Server upgrade-> lost UDFs |
---|---|
Author | Chuck Belanger |
Post date | 2011-01-25T20:23:31Z |
Hello:
Last week I upgraded my clinic computer from XP to Win7. I was using FB
embedded for an application that I created.
I was having trouble with the database processes of an application I
developed (and about 50 people use) and thought to upgrade from FB
v2.1.3 to v2.5.0, embedded. It seemed to help, but some of the issues
continued (OnCallBack to a progress meter in IBO and the program was on
occasion becoming non-responsive without an error message.), so I
thought to try the FB server, since I use that on my development system
and have none of those problems.
I set up the FB server for users of the program as an application and
load it on start up, since I also have a medical device which uses
Interbase and I thought this would be easier to set up under similar
circumstances for the users.
The FB server was noticeably better with less of the above mentioned
errors, but there was still some occasional issues with a non-responsive
program. I finally found out what it was: During a DB update routine
which has many processes, there are times I need to disconnect and
reconnect to the DB. I have about 4 places in the DB update routine that
do that. Seemingly randomly, it was hanging on one of those locations in
the code (I put many messages on the status bar to help with any
non-program errors, so I can know approximately where in the program
things occur), waiting on the server to be connected again. Suddenly
Win7 is much more sensitive to that process. BTW, I fixed it by using
GFIX in a ShellExecuteEx routine, rather than simply Disconnect/Connect.
But, now I'm having a lingering problem with an UDF in FreeUDFLib.dll.
It is one I created, but it looks like even the ones that come with the
dll give the same error, and only on one computer:
Invalid token.
Invalid request BLR at offset 60
Function <> is not defined.
Module Name on entry point could not be found.
The file structures are the same: /UDF is below the /Bin director on the
same branch
All three are using the same FreeUDFLib.dll, in the UDF directory.
The functions are listed UDFs in IBExpert and IB_SQL
I tried to readd the functions under a different name, that just gave
the same error
I tried to backup/restore my database on the computer in question and
that did not help.
All three systems use the same firebird.conf file, which uses the
default UDF location setting.
Any suggestions on what is going on and what I can do to get these
functions back?
Thank you,
Chuck Belanger
Last week I upgraded my clinic computer from XP to Win7. I was using FB
embedded for an application that I created.
I was having trouble with the database processes of an application I
developed (and about 50 people use) and thought to upgrade from FB
v2.1.3 to v2.5.0, embedded. It seemed to help, but some of the issues
continued (OnCallBack to a progress meter in IBO and the program was on
occasion becoming non-responsive without an error message.), so I
thought to try the FB server, since I use that on my development system
and have none of those problems.
I set up the FB server for users of the program as an application and
load it on start up, since I also have a medical device which uses
Interbase and I thought this would be easier to set up under similar
circumstances for the users.
The FB server was noticeably better with less of the above mentioned
errors, but there was still some occasional issues with a non-responsive
program. I finally found out what it was: During a DB update routine
which has many processes, there are times I need to disconnect and
reconnect to the DB. I have about 4 places in the DB update routine that
do that. Seemingly randomly, it was hanging on one of those locations in
the code (I put many messages on the status bar to help with any
non-program errors, so I can know approximately where in the program
things occur), waiting on the server to be connected again. Suddenly
Win7 is much more sensitive to that process. BTW, I fixed it by using
GFIX in a ShellExecuteEx routine, rather than simply Disconnect/Connect.
But, now I'm having a lingering problem with an UDF in FreeUDFLib.dll.
It is one I created, but it looks like even the ones that come with the
dll give the same error, and only on one computer:
Invalid token.
Invalid request BLR at offset 60
Function <> is not defined.
Module Name on entry point could not be found.
The file structures are the same: /UDF is below the /Bin director on the
same branch
All three are using the same FreeUDFLib.dll, in the UDF directory.
The functions are listed UDFs in IBExpert and IB_SQL
I tried to readd the functions under a different name, that just gave
the same error
I tried to backup/restore my database on the computer in question and
that did not help.
All three systems use the same firebird.conf file, which uses the
default UDF location setting.
Any suggestions on what is going on and what I can do to get these
functions back?
Thank you,
Chuck Belanger