Re: [sqlite] Problem opening a new SQLite3 database file
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: > ** > "Cannot find the file 'SQLite3' (or one of its components). Make > sure the path and filename are correct and that all required libraries are > available." > *** > The only thing I can do is open the SQLite3.exe file and work directly off > of it, but I > cannot save anything. > > I have the following files in a folder located on the C drive: > > 1. sqlite3.exeapplication > 2. sqlite3_analyzer application > 3. sqlite3.dll > 4. tclsqlite3.dll > 5. sqlite3.def > 6. fts2.def > 7. fts2.dll > > This happens on my two (Win XP, Win 98SE) home computers and my work > computer (Win 2000). Can anybody help me figure this out so I can start > creating my database? I'd > greatly appreciate it. Thanks My advice to you, as not many people still know how to work well with the windows command line, is to get and use one of the sqlite GUIs that let you use sqlite databases using a graphical manager. Just select one in the http://www.sqlite.org/cvstrac/wiki?p=ManagementTools page, preferably an open source one (I'm sure there are good ones that deserve the money one pays for them, but it's stupid to pay before you know the limitations of the free alternatives). The reason I don't explain why your way doesn't work is because if you don't know what a PATH is then it's hard to say how to open a command line and start typing DOS commands. Regards, ~Nuno Lucas > Dennis Achá - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem opening a new SQLite3 database file
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: <> 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.
Re: [sqlite] Problem opening a new SQLite3 database file
Hello Dennis, Thursday, August 23, 2007, 6:05:09 PM, you wrote: DA> I cannot open a new SQLite3 database file through the command prompt. In DA> the DA> windows "run" window, I type "SQLite3 mydatabase.db3" and I get the DA> following error DA> message: DA> ** DA> "Cannot find the file 'SQLite3' (or one of its components). Make DA> sure the path and filename are correct and that all required libraries are DA> available." DA> *** DA> The only thing I can do is open the SQLite3.exe file and work directly off DA> of it, but I DA> cannot save anything. DA> I have the following files in a folder located on the C drive: DA> 1. sqlite3.exeapplication DA> 2. sqlite3_analyzer application DA> 3. sqlite3.dll DA> 4. tclsqlite3.dll DA> 5. sqlite3.def DA> 6. fts2.def DA> 7. fts2.dll DA> This happens on my two (Win XP, Win 98SE) home computers and my work DA> computer (Win 2000). Can anybody help me figure this out so I can start DA> creating my database? I'd DA> greatly appreciate it. Thanks DA> Dennis Achá DA> _ DA> A new home for Mom, no cleanup required. All starts here. DA> http://www.reallivemoms.com?ocid=TXT_TAGHM&loc=us DA> - DA> To unsubscribe, send email to [EMAIL PROTECTED] DA> - First thing I'd do is open a real command prompt window. CD to the folder that contains the EXE's and try it from the command prompt. That error suggests Windows doesn't know where SQLite3.exe is so, you may want to try C:\Sqlite3.exe or wherever the path is. Personally, I think you need to open a command prompt and work from there and not try doing the "Run" thing till you get the command prompt version working. -- Best regards, Tegmailto:[EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem opening a new SQLite3 database file
What folder are you in at the command prompt when you type "SQLite3 mydatabase.db3"? Does it actually contain SQLite3.exe? If not, you need to specify the full path, or navigate to the folder first. Michael Hooker On 23/08/2007 23:05:09, 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: ** "Cannot find the file 'SQLite3' (or one of its components). Make sure the path and filename are correct and that all required libraries are available." *** The only thing I can do is open the SQLite3.exe file and work directly off of it, but I cannot save anything. I have the following files in a folder located on the C drive: 1. sqlite3.exeapplication 2. sqlite3_analyzer application 3. sqlite3.dll 4. tclsqlite3.dll 5. sqlite3.def 6. fts2.def 7. fts2.dll This happens on my two (Win XP, Win 98SE) home computers and my work computer (Win 2000). Can anybody help me figure this out so I can start creating my database? I'd greatly appreciate it. Thanks - To unsubscribe, send email to [EMAIL PROTECTED] -