?
Solved

installation of firebird 2 client for Delphi application

Posted on 2008-06-10
21
Medium Priority
?
1,730 Views
Last Modified: 2013-12-09
I have installed a Firebird superserver on a machine
I plan to write a client application running on other networked machines that will need to access the Firebird database
The application is written in Delphi using Interbase component (I already succeeded this with the Firebird embedded server but now this application of for multi-users)
What exactly do I have to copy on the client machine and where ?
Can I avoid to run an "installer" ?
Thanks
0
Comment
Question by:LeTay
  • 11
  • 8
  • 2
21 Comments
 

Author Comment

by:LeTay
ID: 21759151
I want to use the Interbase components, native in Delphi
But for this some Firebird client files must be installed on the client PC
My question is which ones ?
The references you provide do not answer this question..
0
 
LVL 14

Expert Comment

by:Daniel Junges
ID: 21759292
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
LVL 2

Accepted Solution

by:
Ustin19 earned 2000 total points
ID: 21766599
for native usage: deploy GDS32.DLL to client's system32 and all will work fine
0
 

Author Comment

by:LeTay
ID: 21766984
Well, I have copied gds32.dll in the client system32 but I still get an error message when starting the .exe (I translate, it is in french) Interbase DLL gds32.dll not found in the path. Please install Interbase to use this functionality
???
0
 
LVL 2

Expert Comment

by:Ustin19
ID: 21767337
try put gds32.dll into directory with exe
0
 
LVL 2

Expert Comment

by:Ustin19
ID: 21767369
try to deploy with exe (to the exe folder):
fbclient.dll
ib_util.dll
icudt30.dll
icuin30.dll
icuuc30.dll
msvcp71.dll
msvcr71.dll
and rename fbclient.dll to gds32.dll
This files located in "C:\Program Files\Firebird\Firebird_2_0\bin\"
0
 
LVL 2

Expert Comment

by:Ustin19
ID: 21767387
any registry\system installations NOT requires
0
 

Author Comment

by:LeTay
ID: 21767432
Tried. I get exactly the same message (gds32.dll not found in the path)
0
 
LVL 2

Expert Comment

by:Ustin19
ID: 21767546
try explicitly choose tibdatabase.libraryName (if it is possible to use FIB) or look to IBHeader.pas and explicitly choose gdi32.dll (if it is not).
Then it may be corrupted gdi32.dll (code of loading is very simple)
0
 
LVL 2

Expert Comment

by:Ustin19
ID: 21767549
 IBLibrary := LoadLibrary(PChar(IBASE_DLL));
  if (IBLibrary > HINSTANCE_ERROR) then <some getprocaddress calls, one of them fails>. So check version
0
 

Author Comment

by:LeTay
ID: 21767649
Well, the gdi32.dll I put on the client is the one I found on the server where I installed the full thing.
LibraryName is not a property of TIBDatabase (Turbo Delphi 2006).
Info : the application runs fine on the server itself, and also on another client where I installed Firebird client only using the installer of Firebird. But I want to avoid having to do this (except if not possible otherwise), and "deliver" just what is needed (I like installers that just need to copy a few files)
0
 
LVL 2

Expert Comment

by:Ustin19
ID: 21767807
try to deploy firebird.msg near gds32.dll (or near executable)
0
 
LVL 2

Expert Comment

by:Ustin19
ID: 21767859
GDI32.DLL is my mistyping!
Have just trided on clear windows: copying firebird.msg & fbclient.dll to the folder with application solves described problem
0
 

Author Comment

by:LeTay
ID: 21768321
Yes of course, gds32.dll, not gdi
I copied everything but the message is still the same : Interbase DLL gds32.dll not found etc...
0
 
LVL 2

Expert Comment

by:Ustin19
ID: 21769305
gds32 imports:
ADVAPI32.dll KERNEL32.dll MPR.dll MSVCR71.dll USER32.dll WS2_32.dll
if MSVCR71.dll does not exists (you may have troubles with environment variables) - create it or put into same dir with gds32 and exe.
Also it can needed to have record in C:\WINDOWS\system32\drivers\etc\services:
gds_db 3050/tcp
so, last chance is using instreg.exe from C:\Program Files\Firebird\Firebird_2_0\bin\ :(

BTW, is exe run from you account? does it have correct permissions (this is for cleaning of conscience only)?
0
 

Author Comment

by:LeTay
ID: 21769415
All these DLL are present (I copied the msvcr71.dll manually)
The problem is NOT that the exe can't connect to a Firebird server because the error message is displayed when the .exe loads
The exe I wrote does NOT connect to the DB when it starts, this is done later on, on user action...
0
 
LVL 2

Expert Comment

by:Ustin19
ID: 21769792
During initialization tIBDatabase calls LoadIBLibrary from IBIntf, which creates this exception /it is DELPHI EXCEPTION, no static imports from GDS32 presents in  your exe.
Detailed analize shows, that this type of exception seldom appears (where i use t(f)ibdatabase in widows services), solution is force copy gds32.dll to global environment var %path% and (very seldom) reboot server (use on w2k3) {sorry 4 my english}
0
 
LVL 2

Expert Comment

by:Ustin19
ID: 21769820
try to use instreg.exe, i'm so interesting in result :)
And what happens, if you use FIB* components instead IB*? FIB* compatible with IB* and have a lot of features (poor that it is shareware AFAIK)
0
 

Author Comment

by:LeTay
ID: 22902643
I found what the problem is : the gds32.dll or some depending other dll gives a kind of "access denied" when trying to open it !
That gave the error
0
 

Author Closing Comment

by:LeTay
ID: 31465737
Also other DLL have to be deployed and it works fine
Thanks !
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Among the most obnoxious of Exchange errors is error 1216 – Attached Database Mismatch error of the Jet Database Engine. When faced with this error, users may have to suffer from mailbox inaccessibility and in worst situations, permanent data loss.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

599 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question