On Fri, 10 Dec 2004, Markus Hoenicka wrote:
>Hi,
>
>I've just built 2.8.15 on Cygwin which worked without a hitch (thanks to
>those who added Cygwin support in the past). However, I came across a
>problem that makes working with databases a bit inconvenient. It seems
>like the library does not understand absolute paths, only relative paths.
>You can simply test this with the command line tool sqlite:
>
>[EMAIL PROTECTED] ~/lit
>$ sqlite /usr/local/share/refdb/db/refdb
>SQLite version 2.8.15
>Enter ".help" for instructions
>sqlite> select * from CITSTYLE;
>Unable to open database "/usr/local/share/refdb/db/refdb": unable to open
>database: /usr/local/share/refdb/db/refdb
>
>The same problem occurs if I use an application linked against libsqlite. If I
>set the absolute path to the database file, the app fails. If I start the app
>in / and pass the relative path, the app works ok.
>
>I'm currently away from my Linux/BSD boxes, so I can't tell whether this
>problem
>is specific to Cygwin. Can anyone help?
This looks like a cygwin and/or your cygwin environment problem. sqlite
works fine with absolute path on my Linux box, with 2.8.15.
We're using sqlite with absolute paths in production code across Solaris,
Linux, Windows, HP-UX and AIX with no problems.
>
>regards,
>Markus
>
Christian
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \