Recent

Author Topic: [Firebird + Zeos] Can't connect to server  (Read 5240 times)

Serpente80

  • New Member
  • *
  • Posts: 29
[Firebird + Zeos] Can't connect to server
« on: March 14, 2013, 12:49:35 pm »
I'm working on Zeos + Firebird.
My app works perfectly on the server, but can't find DB from the client in a LAN.
This is my config
--------------------------------------
Server:
Database path = c:\db.fdb
Alias = db = c:\db.fdb

Client:
Alias = db = ServerIP:c:\db.fdb

Zconnection.database = db
-------------------------------------------

Is something wrong ?
Flamerobin can connect from the client, my app, no.
Help please.

EgonHugeist

  • Jr. Member
  • **
  • Posts: 73
Re: [Firebird + Zeos] Can't connect to server
« Reply #1 on: March 14, 2013, 01:23:13 pm »
You should use:

TZConnection.Host = YourServer_IP;
TZConnection.Port = YourServer_Port;

Serpente80

  • New Member
  • *
  • Posts: 29
Re: [Firebird + Zeos] Can't connect to server
« Reply #2 on: March 14, 2013, 01:45:21 pm »
I think i tried.

cdbc

  • Sr. Member
  • ****
  • Posts: 262
    • http://www.cdbc.dk
Re: [Firebird + Zeos] Can't connect to server
« Reply #3 on: March 14, 2013, 02:46:04 pm »
Hi
Did you remember the Firebird client library?!? Zeos needs that in order to connect to the Firebird server.
On windows it's called "fbclient.dll" and is mostly located in the system directory.
Hint: http://www.destructor.de/firebird/minimumclient.htm
On linux, try googling it  ;)
Regards Benny
If it ain't broke, don't fix it ;)

Serpente80

  • New Member
  • *
  • Posts: 29
Re: [Firebird + Zeos] Can't connect to server
« Reply #4 on: March 14, 2013, 03:10:08 pm »
Yes, fbclient.dll it's in system folder.
As i said, flamerobin works.

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: [Firebird + Zeos] Can't connect to server
« Reply #5 on: March 14, 2013, 03:29:44 pm »
Does the bitness match - i.e. are you using a 32 bit fbclient.dll with a 32 bit application or a 64 bit fbclient with a 64 bit application?

If Flamerobin works on your machine, the problem obviously is with your code (or Zeos), so I think actuall source snippets may be handy (instead of just mentioning "I think I tried that").
Don't use Zeos myself though, but others may be able to help you.

Finally, please specify OS+Lazarus+FPC version, see my signature - a good way to do this is to put it in your profile signature so it appears with every post on the forum.
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

Serpente80

  • New Member
  • *
  • Posts: 29
Re: [Firebird + Zeos] Can't connect to server
« Reply #6 on: March 14, 2013, 04:05:08 pm »
I'm using 32bit firebird on Windows XP 32bit and Lazarus 1.1 32bit + FPC 2.6.1 + Zeos 7.1.0 alpha.
I will try the zconnection settings without alias.
« Last Edit: March 14, 2013, 04:09:00 pm by Serpente80 »

Serpente80

  • New Member
  • *
  • Posts: 29
Re: [Firebird + Zeos] Can't connect to server
« Reply #7 on: March 14, 2013, 04:34:19 pm »
I tried without alias, with absolute path for DB, 3050 for port and .. IT WORKS !
Tnx Egon !

 

TinyPortal © 2005-2018