in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Compatibility problems

Last post 04-10-2008 5:51 PM by Robert Simpson. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 02-29-2008 4:21 AM

    Compatibility problems

    I tried to open a sqlite database generated by the system.data.sqlite in php using sqlite_open and versa vi, but it didn't work. The system.data.sqliteconnection tells me that the file generated by php isn't a sqlite database, and the php tels me the same thing about sqlite. What do I do? I realy need that to work. I thought that SQLite should work with SQLite in every platform. Please help. 

    Filed under: ,
  • 02-29-2008 9:00 AM In reply to

    • Nate
    • Top 10 Contributor
    • Joined on 08-28-2005
    • Fort Collins, CO
    • Posts 69

    Re: Compatibility problems

     Did you use a password with the database generated by the data provider? If so, it is encrypted and any other implementation of SQLite cannot read the files.

  • 03-01-2008 10:48 AM In reply to

    Re: Compatibility problems

     No. I didn't.

  • 04-10-2008 5:51 PM In reply to

    Re: Compatibility problems

    You'll have to find out what version of SQLite PHP you have.  SQLite is backward compatible but not forward compatible.  It's likely the SQLite version in your PHP installation is older than the version of the engine in System.Data.SQLite.

Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems