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 equal to y but x and y
greater than 0.

Regards,
Durga.
On Tue, Jul 20, 2010 at 1:58 PM,  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

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 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.

The application could be failing to create the journal
file. Check it has permission to create new files in the
directory the database file is stored in.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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 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

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

On Tue, Jul 20, 2010 at 4:28 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 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

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 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

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 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".


Thanks,
Preeti
 

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Sereda
Sent: Monday, July 19, 2010 3:15 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] "Unable to Open DB" on Win-7 & Vista (64 bitt) on
UAC -ON


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, keep the file under
C:\Users\currentUser\AppData\Roaming\yourapp

-- Igor

--
View this message in context:
http://old.nabble.com/%22Unable-to-Open-DB%22-on-Win-7---Vista-%2864-bit
t%29-on-UAC--ON-tp29202752p29202990.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

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, keep the file under C:\Users\currentUser\AppData\Roaming\yourapp

-- Igor

-- 
View this message in context: 
http://old.nabble.com/%22Unable-to-Open-DB%22-on-Win-7---Vista-%2864-bitt%29-on-UAC--ON-tp29202752p29202990.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users