Trying to connect to SQLite database |
[eluser]imorris[/eluser]
I'm using CI 1.73 and the SQLite DB driver (http://codeigniter.com/wiki/PDO_SQLite3/) to connect to a sqlite database. I can successfully connect to the database using plain php code: Code: <p>PDO TEST: SQLITE 3.x</p> ...but I can't connect to the database using Codeigniter's database driver. Can someone help? Code: $active_group = "default";
[eluser]imorris[/eluser]
Good news, I got connected to my database. My problem was because of the database being in the wrong path. Now, my problem is that when I use active records to run a basic "select" statement I get the following error: A Database Error Occurred Error Number: 1 unsupported file format SELECT * FROM tbl1 I used the sqlite instructions to setup my test database. I don't know why I'm getting this error. Any thoughts? Here's the instructions I used to create the database. I can successfully run SQL statements against it manually. http://www.sqlite.com/sqlite.html
[eluser]tanero[/eluser]
I don't know why the sqlite database is so problematic, but it seems your problem related to version of sqlite database. your are trying to connect by sqlite3 driver to sqlite2 db.
[eluser]imorris[/eluser]
[quote author="tanero" date="1300028310"]I don't know why the sqlite database is so problematic, but it seems your problem related to version of sqlite database. your are trying to connect by sqlite3 driver to sqlite2 db.[/quote] Thank you for your response. I did successfully get connected but it took some doing on my part. I had to upgrade PHP, install various PHP - SQLite extensions, and use the following server configuration to get connected: Code: $active_group = "messageresend"; |
Welcome Guest, Not a member yet? Register Sign In |