If your end user controls where to put the database file then after receiving error "Unable to open database" you should tell him to change permissions on that file to be accessible to everybody. Don't forget to tell him to change permissions on the directory where database resides too.
Pavel On Tue, Jul 20, 2010 at 4:28 AM, <preeti.yad...@wipro.com> wrote: > In my case, the DB is created by the older version of application and > now the new version of application is installed and End user has option > to see old data with selecting old version of DB so its completely on > end user wish to choose the location for DB. And also new tables in DB > are created to new version of application, on select of old DB, > application has to create those tables in OLD DB also to synch. > > Application is successfully executing select query on UAC-ON however > while executing DDL and DML it is throwing "Unable to open Database". > > Please guide us on this issue. > > Please let me know if it is not clear to you all. > > Thanks, > Preeti > > > > ________________________________ > > From: Preeti Yadav (WT01 - Healthcare and Services) > Sent: Monday, July 19, 2010 1:47 PM > To: 'sqlite-users@sqlite.org' > Subject: "Unable to Open DB" on Win-7 & Vista (64 bitt) on UAC -ON > > > Hello Team, > > I am using SQLite DB for java/Swings based desktop application. We are > facing below issue on Win-7 & Vista (64 bit) Operating System only on > UAC -ON (User access Control). > > Current version of application is unable to do any DDL/ DML on DB > Created by older version of application on Win-7 & Vista (64 bit) > Operating Systems only on UAC -ON (User access Control). We found that > DB is throwing "Unable to Open DB". Everything is working perfectly if > we set UAC to Never Notify. > > We do not have any problems with other OS like Win-xp, Mac, etc. > > We request you to please guide us on this issue. > > Please let me know if you need more information. > > Thanks in advance for your kind help!! > > Warm Regards, > Preeti > > > Please do not print this email unless it is absolutely necessary. > > The information contained in this electronic message and any attachments to > this message are intended for the exclusive use of the addressee(s) and may > contain proprietary, confidential or privileged information. If you are not > the intended recipient, you should not disseminate, distribute or copy this > e-mail. Please notify the sender immediately and destroy all copies of this > message and any attachments. > > WARNING: Computer viruses can be transmitted via email. The recipient should > check this email and any attachments for the presence of viruses. The company > accepts no liability for any damage caused by any virus transmitted by this > email. > > www.wipro.com > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
