Re: [sqlite] "Unable to Open DB" on Win-7 & Vista (64 bitt) on UAC -ON

2010-07-21 Thread Durga D
Try to launch your appliztion with "Run As Administrator"(right click on exe -> Run As..). Note: Take care about fields information for old DB and new DB while opening tables(backward compatibility). For ex: old DB might have x number of fields and new DB might have y number fields where x is not

Re: [sqlite] "Unable to Open DB" on Win-7 & Vista (64 bitt) on UAC -ON

2010-07-21 Thread Dan Kennedy
On Jul 21, 2010, at 11:12 AM, 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

Re: [sqlite] "Unable to Open DB" on Win-7 & Vista (64 bitt) on UAC -ON

2010-07-20 Thread preeti.yadav1
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

Re: [sqlite] "Unable to Open DB" on Win-7 & Vista (64 bitt) on UAC -ON

2010-07-20 Thread Pavel Ivanov
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

Re: [sqlite] "Unable to Open DB" on Win-7 & Vista (64 bitt) on UAC -ON

2010-07-20 Thread preeti.yadav1
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

Re: [sqlite] "Unable to Open DB" on Win-7 & Vista (64 bitt) on UAC -ON

2010-07-19 Thread preeti.yadav1
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

Re: [sqlite] "Unable to Open DB" on Win-7 & Vista (64 bitt) on UAC -ON

2010-07-19 Thread Igor Sereda
I suspect the permissions set on DB file allow only Administrators to change it; and that requires escalation to Admin rights under UAC. It's likely that your DB file is located in C:\Program Files\yourapp. As a solution, you could relax permissions on the DB file upon installation, or, better,

[sqlite] "Unable to Open DB" on Win-7 & Vista (64 bitt) on UAC -ON

2010-07-19 Thread preeti.yadav1
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