[EMAIL PROTECTED] wrote: > > I have a website on a shared hosting which has PHP 5 installed on it. I > ran a test program and created a SQLite database from it. When I opened > the database file, it has as its first line "This file contains an > SQLite 2.1 database". I am trying to download the 2.1 version of SQLite > from the internet(google) but unable to get any windows binary for it. > The SQLite.org website does not carry binaries of older versions. > > I also tried to search in the sqlite-users mailing list, but the site > does not have a search option, and the messages are stored month wise, > so I do not know whether this has been answered before on this mailing > list. > > Where can I get it? Any help would be greatly appreciated. >
Older version of SQLite are aviable from the website, but there are no direct links on the web pages. You need to manually edit the links to get the file you need. The 2.1 version of the database file implies that it was created with a 2.X.Y version of SQLite. You should get the latest version which is 2.8.17 (I believe). If you go the download page http://www.sqlite.org/download.html and the right click on the link to download the latest Windows binary file, then select Copy Link Location (at least using Firefox, in IE the command is Copy Shortcut). Now open a new tab or window and paste the link into the address bar. You can edit the link and replace the version number with the version you want to download. In your case you need to change http://www.sqlite.org/sqlitedll-3_5_6.zip to http://www.sqlite.org/sqlitedll-2_8_17.zip and then press enter to start the download. This process can be used to get previous versions of the DLL and the command line shell program (and probably all other files as well). HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users