file is encrypted or is not a database

Hi all. I’ve been playing around with the Corona SDK for a bit now and have decided to use it to develop games and apps.

Currently I am building an app that downloads a sqlite database that is populated through a web admin interface. I am doing this so that data on the website and app can be in sync.

I can download the database in the app fine. However, when I try to view the data in it using a SELECT I get a ‘file is encrypted or is not a database’ error. The database has no password and I’ve tried creating the database in the app and then uploaded that (thinking it may be a sqlite version issue).

I know I could expose the data in the web database as XML or JSON and use that but that would take me quite a bit extra dev time.

So can anyone help with my current method?

Thanks

rasith [import]uid: 25939 topic_id: 9843 reply_id: 309843[/import]