Firebird embedded dynamic connect.

[markhorrocks]

I am trying to set SQLQuery1.DatabaseName := ExtractFilePath(ParamString(0) + 'mydb.fdb' in the form create or show events and I get an file open error that its still looking for the design time file.

How can I set a db path name based on the current install path dynamically. This works fine if I leave the path set in design time. Problem with that is that I don't know whether program files will be (x64) or not.

This works fine in Delphi using Firebird server but i want to use embedded.

[goldenfox]

Maybe set it like this?

Code: [Select]

SQLQuery1.Database := IBConnection1;
IBConnection1.Databasename := /path/to/mydb.fdb

 

[markhorrocks]

Maybe set it like this?

Code: [Select]

SQLQuery1.Database := IBConnection1;
IBConnection1.Databasename := /path/to/mydb.fdb

Now I see that it has nothing to do with setting the DatabaseName in code. Now, I get the same error at runtime even when i leave it set at design time where it can connect.

[BigChimp]

Strange.

Storing your database in program files is not a smart move, security wise (unless it's a read only db, I suppose). See the wiki articles on cross platform programming and windows for some ideas on where to store data files.
You might be having permission problems (access denied) - but then it's strange it works at design time and not at run time.

Edit: oh, if it works at design time, not at run time: please make sure the firebird embedded dlls are present in the application directory (or windows\system32 directory, I suppose, but I wouldn't go that route).

Hint: posting your Lazarus version, platform (obviously some form of Windows) and actual code is not a bad idea when posting...

[markhorrocks]

I think I have this figured out. The sigsegvs seem to be due to having a separate IBconnection component in each form. When I refactored that to having a single IBconnection in the main form the issue seemed to be resolved. In Delphi I used a single database in a separate RDM app.

The connection errors were a problem to me because I had the server running at the same time as trying to make the app work with embedded. I gave up embedded and stuck to the server and everything seems ok now.

[markhorrocks]

Storing your database in program files is not a smart move, security wise (unless it's a read only db, I suppose). See the wiki articles on cross platform programming and windows for some ideas on where to store data files.

My first bright ideas was just to install the lot in c:\myapp but whatever antivurus or something installed on the clients computer complained that myapp might be malware. I guess because it wants to install into the root directory.

Hint: posting your Lazarus version, platform (obviously some form of Windows) and actual code is not a bad idea when posting...

I was getting round to making up a demo but then the eureka moment hit me. Its windows running in a vbox vm. I normally operate in ubuntu. This is the only GUI app I'll probably ever do :-)

[markhorrocks]

I still can't get this to work. No matter where I try to set my database name in code, I still get an error saying it can't find the design time path.