Ok, I found the "error". In dbSQLite line 16. It gets the path of the database, but unless you have specified an absolute path, dbapi will try to load it from the current working directory. The database is then created if it doesn't exist.
By just setting the current working directory to the applications directory this is fixed. This is not a dabo issue after all, but just the way sqlite works. My fault for not checking how sqlite works. -Simen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simen Haugen Sent: 29. august 2006 11:40 To: Dabo Users list Subject: RE: [dabo-users] Problems with SQLite It happens when executing a query, but it only happens when the project is compiled with py2exe (or at least that's when I have experienced it. I also had problems with unable to open database, but setting the timeout property helped). When the error occurs, no commands against the sqlite db is working - isExistsingTable, getTables etc. These functions don't throw an exception, but returns False, None etc. Perhaps it has problems opening the database sometimes, and just skipping the exception? I can't find anything on google, but perhaps my search is a bit generic as I don't know what the problem might be. -Simen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul McNett Sent: 23. august 2006 18:36 To: Dabo Users list Subject: Re: [dabo-users] Problems with SQLite Simen Haugen wrote: > I don't think this has anything to do with Dabo, but I'll give it a > shot. (sqlite mailinglist next) > > I'm having some problems with SQLite. Sometimes I get an error "could > not open database". Other times I get "No such table xxx". I only have > one instance of the application up running against the database, and I'm > not deleting any tables. These errors only happen sometimes, and it > usually works if I just try it once more. > > Any idea what might be causing the problems? No, but you should post your traceback here just in case. Also, does it always occur on the same line in Dabo? My money is on something wrong with Dabo, not sqlite, especially if googling doesn't turn up anything. -- Paul McNett http://paulmcnett.com http://dabodev.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
