Firebird SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed ForumsDatabasesFirebird SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old June 20th, 2012, 11:15 AM
Alex_hybrid Alex_hybrid is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2012
Posts: 3 Alex_hybrid User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 18 m 55 sec
Reputation Power: 0
Connecting to two different FB servers

Hi, I am new here and looking for some help.
I have a software that is running on FB2.0. Client part installed on my PC and connects to the server (FBSerevr1).
I also have another application that is using FB 2.5 and running on another server (FBServer2).
Question: how do I tell client pc to which instance of fbclient to connect.
At the moment the only way I found is to edit registry key defaultInstance and point to corresponding FB client folder.

Thanks

Reply With Quote
  #2  
Old June 21st, 2012, 04:24 AM
tsteinmaurer tsteinmaurer is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Oct 2010
Posts: 34 tsteinmaurer User rank is Lance Corporal (50 - 100 Reputation Level)tsteinmaurer User rank is Lance Corporal (50 - 100 Reputation Level)tsteinmaurer User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 5 h 2 m 19 sec
Reputation Power: 3
Hello,

put the Firebird client files into the same directory as your client application executable and it should pick up the client files from there. Which client libraries are loaded by your application can be easily checked with e.g. SysInternals Process Explorer.

Reply With Quote
  #3  
Old June 21st, 2012, 06:54 AM
Alex_hybrid Alex_hybrid is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2012
Posts: 3 Alex_hybrid User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 18 m 55 sec
Reputation Power: 0
Quote:
Originally Posted by tsteinmaurer
Hello,

put the Firebird client files into the same directory as your client application executable and it should pick up the client files from there. Which client libraries are loaded by your application can be easily checked with e.g. SysInternals Process Explorer.

Thank you for your reply...
I tried putting in gds32.dll and fbclient.dll from FB 2.5 into my application folder but it still wouldn't work.
As I said before the only way to have them working is to modify
defaultinstance value in
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Firebird Project\Firebird Server\Instances .

Any way to specify instance in connection string?
thanks

Reply With Quote
  #4  
Old June 21st, 2012, 07:10 AM
tsteinmaurer tsteinmaurer is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Oct 2010
Posts: 34 tsteinmaurer User rank is Lance Corporal (50 - 100 Reputation Level)tsteinmaurer User rank is Lance Corporal (50 - 100 Reputation Level)tsteinmaurer User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 5 h 2 m 19 sec
Reputation Power: 3
Quote:
Thank you for your reply... I tried putting in gds32.dll and fbclient.dll from FB 2.5 into my application folder but it still wouldn't work. As I said before the only way to have them working is to modify defaultinstance value in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Firebird Project\Firebird Server\Instances .

Any chance that you copied 64-bit versions of gds32.dll and fbclient.dll from a 64-bit Firebird Server installation into your application directory, while your application is 32-bit?
Quote:
Any way to specify instance in connection string?

Only by providing the TCP port of the destination Firebird server in the connect string like server/port:<database_path>

Thomas

Reply With Quote
  #5  
Old June 21st, 2012, 08:14 AM
Alex_hybrid Alex_hybrid is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2012
Posts: 3 Alex_hybrid User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 18 m 55 sec
Reputation Power: 0
Quote:
Originally Posted by tsteinmaurer
Any chance that you copied 64-bit versions of gds32.dll and fbclient.dll from a 64-bit Firebird Server installation into your application directory, while your application is 32-bit?

Only by providing the TCP port of the destination Firebird server in the connect string like server/port:<database_path>

Thomas

THANK YOU SO MUCH,
specifying the port number worked like a charm!!!!

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesFirebird SQL Development > Connecting to two different FB servers

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap