On 8/23/07, Dennis Achá <[EMAIL PROTECTED]> wrote: > I cannot open a new SQLite3 database file through the command prompt. In > the > windows "run" window, I type "SQLite3 mydatabase.db3" and I get the > following error > message:
<<snip>> Using Start Menu/Run is not the most flexible way of running the SQLite command line utility. The error message you are getting is being generated because the directory where you placed the SQLite files is not defined in your PATH variable so they cannot be found from the Run window. To modify the PATH variable in XP: 1. Right click on My Computer. 2. Select 'Properties' 3. Click the 'Advanced' tab. 4. Locate the 'Environment Variables' button and click it. 5. On the bottom half of the screen under 'System Variables' select 'Path' (you may have to scroll down to find the the Path variable). 6. Click the 'Edit' button. 7. Add the directory where you placed the SQLite files (make sure you include a semicolon (;) before the new entry). While not advisable, you can also copy/move the SQLite files to a directory already defined in the PATH variable and running the SQLite3.exe should work. I haven't worked with Win98 in a long time so I'm not sure where the Environment Variables settings are located for that OS.
