Getting No Such Table error with Sqlite 3

[eluser]johnnyForums[/eluser]
I installed the PDO fix for sqlite 3 and have it running. I get no errors when loading the database.

But when I do scaffolding I get:
No such table

The table is actually northwind from microsoft and has a table named customers. I have tried customers and Customers. The only thing I can see happening is that in my folder where I have my sqlite database is that CodeIgniter creates a "ghost" of the database file with the same name as the master. This "ghost" has the same name but is of zero size.



Can anyone help?

edit: I also tried it with just $this->db->get('customers');
but I get the same error and the same ghost database.

This is the wiki I followed:

http://codeigniter.com/wiki/PDO_SQLite3/


I figured it out it is creating the database instead of trying to read my existing database. I change chang the name of the database to anything I want and CI will create the database in my folder.

Why is it doing this??

$db['default']['hostname'] = "localhost";
$db['default']['username'] = "";
$db['default']['password'] = "";
$db['default']['database'] = 'sqlite:'.APPPATH.'db/nwind2009.db';
$db['default']['dbdriver'] = "pdo";