[eluser]remmar[/eluser]
Hi
I'm a newbie.
I need to use MS access as databse and need to setup up on database.php can anyone help me. it's should be dsn-less if possible.
[eluser]InsiteFX[/eluser]
You would need to use odbc driver for access
InsiteFX
[eluser]remmar[/eluser]
do you any sample configuration for database.php
[eluser]remmar[/eluser]
I've have odbc already name "access". btw, the mdb required a password.
and set the database.php
$db['access']['hostname'] = "{Microsoft Access Driver (*.mdb)}";
$db['access']['username'] = "ADODB.Connection";
$db['access']['password'] = "";
$db['access']['database'] = "D:\\Cash Management\\Workbench\\dbMIS.mdb";
$db['access']['dbdriver'] = "odbc";
$db['access']['dbprefix'] = "test";
$db['access']['pconnect'] = TRUE;
$db['access']['db_debug'] = TRUE;
$db['access']['cache_on'] = FALSE;
$db['access']['cachedir'] = "";
$db['access']['char_set'] = "utf8";
$db['access']['dbcollat'] = "utf8_general_ci";
$db['access']['swap_pre'] = '';
$db['access']['autoinit'] = TRUE;
$db['access']['stricton'] = FALSE;
but i have this error.
A Database Error Occurred
Unable to connect to your database server using the provided settings.
Filename: C:\wamp\www\system\database\DB_driver.php
Line Number: 124
[eluser]remmar[/eluser]
Yes i've created one already via odbc. I nammed the system DSN to "access"
[eluser]remmar[/eluser]
anybody I need help
[eluser]Anak Indonesia[/eluser]
$db[‘access’][‘dbprefix’] = “test”; ??
[eluser]Jaketoolson[/eluser]
Yah. Why do you need double backslashes with Ms ACCESS paths? Is this a PHP thing? ODBC Driver thing?