BobW

How to deploy a simple Win 32 app with SQLite file? I just want to be able to set up the deployment to be able to create an executable Windows 32 bit app that has one Sqlite file that I can copy to another machine and execute. Is there a simple way of doing that?

Ok, now when I put the application on another machine it says I need a driver definition file.................. How do I create one of those and where do I tell the application to use it?

When I put $(RUN)\Drivers.db in TFDConnection.Params.Database the application gives me an error saying it can't find the Drivers2 table anymore. Sorry........

I can't find TPath component. Or is it not a component?

Uwe, Thanks for the response. Could you go into more detail for this: Set Params.Database to $(RUN)\Drivers.db How do I use the above? Is that hard coded in the application or a macro definition in Inno SetUp?

Thanks for all of the suggestions. I looked at Inno Setup and it looks like easiest way to deploy a simple Win32 application with a SQLite database file. What settings would I need in my TFDConnection so that it looks locally where it is installed? Just use Inno Setup with the exe and db file, so that the applications looks in the same location as the exe file.

If I use this code it doesn't find my table within my database: DriversConnection.DriverName:='SQLite'; DriversConnection.ConnectionDefName:='Drivers'; DriversConnection.Params.Database:='Drivers.db'; DriversConnection.Params.DriverID:='SQLite'; DriversConnection.Open;

MyProgram.exe and database.db are what I am trying to install on a naive machine and have it run the *exe using the SQLite *.db file locally.