Forum > Databases

IBX - Cannot keep IBDatabase connected at design time and run time (UPDATED)

<< < (2/2)

Eloir:

--- Quote from: tonyw on May 06, 2022, 10:33:10 am ---The first point to make is that IBX for Lazarus has evolved considerably from the version of IBX that you would have used with Delphi 5. Having said that, it should work at least as well.

Looking at the description of your problem: what is the connect string that you are using? Is it simply the filename or does it also include the server name (or localhost:). In the former case, from Firebird 3 onwards, the underlying Firebird Client will connect in embedded mode and will typically gain exclusive access to the database. In the latter case, the Firebird Client will connect as a remote user. This will allow more than one connection to the database.

If this is not your problem then look at the "employee" example and see if you still have the same problem. If not, then the way the example connects to the database may help you.

--- End quote ---

I am usgin simply the filename.
Sorry, I didn't find "employee" example to see another way to connect.
By the way, I have Firebird running as a server, on my computer.

tonyw:

--- Quote from: Eloir on May 06, 2022, 08:13:06 pm ---
--- Quote from: tonyw on May 06, 2022, 10:33:10 am ---The first point to make is that IBX for Lazarus has evolved considerably from the version of IBX that you would have used with Delphi 5. Having said that, it should work at least as well.

Looking at the description of your problem: what is the connect string that you are using? Is it simply the filename or does it also include the server name (or localhost:). In the former case, from Firebird 3 onwards, the underlying Firebird Client will connect in embedded mode and will typically gain exclusive access to the database. In the latter case, the Firebird Client will connect as a remote user. This will allow more than one connection to the database.

If this is not your problem then look at the "employee" example and see if you still have the same problem. If not, then the way the example connects to the database may help you.

--- End quote ---

I am usgin simply the filename.
Sorry, I didn't find "employee" example to see another way to connect.
By the way, I have Firebird running as a server, on my computer.

--- End quote ---
Then try putting "localhost:" before the filename. That will force the client to connect via the server and you should then be in multi-user mode.

Eloir:
Putting "localhost:" before the filename does not work either.
I finally found "employees" database and I saw also how aliases should work, but I think it is not the better way.
So, by now, I will keep designing with disconnected database.
Thank you for your tips.

Navigation

[0] Message Index

[*] Previous page

Go to full version