I have noticed this for sqlite 2.8.15 and 3.0.6 (both compiled under
Cygwin): sqlite doesn't recognise Unix style paths for opening databases
(but "-init unix_path" works). Cygwin itself supports both paths styles.
Symptoms:
[EMAIL PROTECTED] pwd
/home/tkampe
[EMAIL PROTECTED] sqlite3 test.db
Loading resources from /home/tkampe/.config/sqlite/.sqliterc
SQLite version 3.0.6
Enter ".help" for instructions
sqlite> create table test_table(test_col);
sqlite> .exit
[EMAIL PROTECTED] sqlite3 /home/tkampe/test.db
Unable to open database "/home/tkampe/test.db": unable to open database
file
[EMAIL PROTECTED] sqlite3 'C:\cygwin\home\tkampe\test.db'
Loading resources from /home/tkampe/.config/sqlite/.sqliterc
SQLite version 3.0.6
Enter ".help" for instructions
sqlite>
The only difference between 2.8.15 and 3.06 is that 2.8.15 doesn't error
on "sqlite /home/tkampe/test.db" - but on the first connection attempt
to the database ("sqlite> .databases" for instance).
Thorsten
