TIBConnection with Firebird

Forum > Databases

(1/1)

Skot:
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:
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:
AcessViolation: do you set the dialect correctly?

Skot:
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.

Navigation

[0] Message Index