Help!!!! configuration for database.php using ms access dabase |
[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]InsiteFX[/eluser]
You can try the below, but warning you need to setup your Windows odbc data sources. Code: $active_group = 'default'; InsiteFX
[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]InsiteFX[/eluser]
As I stated above you need to setup a Microsoft Access Driver! Read this! InsiteFX
[eluser]remmar[/eluser]
Yes i've created one already via odbc. I nammed the system DSN to "access"
[eluser]Jaketoolson[/eluser]
Yah. Why do you need double backslashes with Ms ACCESS paths? Is this a PHP thing? ODBC Driver thing? |
Welcome Guest, Not a member yet? Register Sign In |