On 1/27/09, Griggs, Donald <donald.gri...@allscripts.com> wrote: > > Venkat, > > If you have a ".db" file it almost certainly *is* an sqlite database. > A great attribute of sqlite databases is that they are contained in a > single file. > > If you're looking for a GUI frontend, they are legion, including good > free ones such as sqlite3explorer and a plug-in sqliteManager for > firefox webbrowser. > See http://www.sqlite.org/cvstrac/wiki?p=ManagementTools > > Donald > =================
Hi Donald, Thanks for the link thats helpful, How do i access the .db file and read the data... ================= Venkat, There may be a bit of a language barrier here. Each of the GUI sqlite utilities can be used to access and read the data in an sqlite database. Each has it's own instructions. Often, one chooses to "open" the database file from within the GUI. One then supplies the desired SQL instructions and asks that they be "executed" by some means. There are even ODBC wrappers available so that you may even be able to use some tool with which you are already familiar. All of the data, of course, is also available by using the Command Line Utility provided as part of the official release. Have you downloaded the utility and/or a GUI front-end? Have you had trouble with the directions provided by them? If you're comfortable with the command line utility, for instance, have you had trouble after reading page, http://www.sqlite.org/quickstart.html ? If so, you may need to elaborate on "access" and "read the data" since I'm not as sure as I was earlier that I understand the difficulty you're having. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
