Ed Leafe wrote: > On Feb 16, 2009, at 11:42 AM, Paul McNett wrote: > >> Then the app won't find it because the db location is relative to >> app.HomeDirectory. >> Do I have that right? > > > Yes, because it works on relative paths, and the relative path > between the cnxml and db is different than the path between > HomeDirectory and the db.
So if we have the rule that the db location is relative to the app location, remind me why the cnxml can't be set like: <database>db/my.sqlite.db</database> This issue isn't really that simple, so I don't have any answers. I just wanted to make sure I understood the issues. I've sidestepped this in my apps by recognizing that the end-user will be controlling the sqlite db location (because in my app the db is a file as in user opens it with File|Open). Unless the db gets distributed with the app, I'm not sure there's a real use-case where the db will be expected to be in a fixed relative path from the application location (could be that the app is in /usr/local/bin and the db is in /var/local/db *or* c:\Program Files\MyApp and f:\data, etc. etc.) Then again this same argument could be made for regular db servers, too. So, as I said, no simple answers. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/[email protected]
