[eluser]Unknown[/eluser]
Thank you for responding.
I did tryout the examples but they did not work.
Below is my modified database.php file:
Code:
$active_group = 'SQLite';
$active_record = TRUE;
$db['SQLite']['hostname'] = 'localhost';
$db['SQLite']['username'] = '';
$db['SQLite']['password'] = '';
$db['SQLite']['database'] = 'sqlite:C:\Users\polar\SQLiteDatabase';
$db['SQLite']['dbdriver'] = 'sqlite';
$db['SQLite']['dbprefix'] = '';
$db['SQLite']['pconnect'] = TRUE;
$db['SQLite']['db_debug'] = TRUE;
$db['SQLite']['cache_on'] = FALSE;
$db['SQLite']['cachedir'] = '';
$db['SQLite']['char_set'] = 'utf8';
$db['SQLite']['dbcollat'] = 'utf8_general_ci';
$db['SQLite']['swap_pre'] = '';
$db['SQLite']['autoinit'] = TRUE;
$db['SQLite']['stricton'] = FALSE;
Notice that I am not referencing the pdo_sqlite driver, but the codeigniter sqlite driver, is this a mistake?
Also, I have used the full path to the sqlite database file, should I have added the actual database I want to access. The tutorials I've seen ony state the PATH to the DB file.
Feedback welcomed.
Thx