TIBConnection with Firebird
lazarus / 16-Databases

----------------------------------------------------------------------
Skot · 2006-02-13 19:35

Hello,

Just trying out Lazarus for the first time.  I installed the most
recent one from Source Forge along with it's prereqs on a fully
updated CentOS Linux boxen.

Just as a test I put a TIBConnection, TDataSource, TSQLQuery and a
TSQLTransaction on my form along with a TdbGrid. 

First, I tried to connect to a remote Firebird Database, but it keeps
saying that it can not connect to Localhost.  So, I started the local
Firebird server and changed everthing to replicate the environment on
the remort machine and tested with ISQL and connects fine, as
expected.  Now I can get TIBConnection to connect, no problem, on
localhost.

Next I linked the TSQLTransaction and TSQLQuery to the TIBConnection
and a TDatasource to the Query and the Grid to the Datasource.  Now,
when I activate the TSQLQuery I get an AV, both in design time and in
run time.

Can anyone point out what I am missing here?

Cheers.

Skot

----------------------------------------------------------------------
JanH · 2006-02-14 09:13

if you want to connect to a remote firebird database you have to set
properties as follows:
 - HostName := ''
 - DatabaseName := 'host:dbName'

I don't know why, but it works fine :-)

----------------------------------------------------------------------
JanH · 2006-02-14 09:17

AcessViolation: do you set the dialect correctly?

----------------------------------------------------------------------
Skot · 2006-02-14 15:39

Suddenly it started working, no more AVs.  I don't think I even
changed anything.  Strange, but, Woohoo!

Something else was strange, I put a couple labels up to display the
HostName and the DataBaseName durring run time, the Hostname was
removed from the DatabaseName and LocalHost was in the HostName even
though I set them both durring designtime and also in runtime.  This
was when I was getting the AVs.  I started a whole new project the
next day and now suddenly it works.