• 0 Vote(s) - 0 Average
• 1
• 2
• 3
• 4
• 5
 Connection to Access jaysondotp Junior Member Posts: 36 Threads: 19 Joined: Nov 2014 Reputation: 0 12-02-2014, 11:09 PM Hi Coders, any body can help, how to connect CI.3 to access 97 sv3tli0 PHP Dev Posts: 421 Threads: 24 Joined: Oct 2014 Reputation: 18 12-03-2014, 01:07 AM I haven't used access for storage with CI. How ever you should be able to use ODBC And with little search I found this 2 threads perhaps they may help you: https://ellislab.com/forums/viewthread/93160/ http://stackoverflow.com/questions/17886...or-cakephp Best VPS Hosting : Digital Ocean Rufnex Chuck Norris Mode - Former CI Council Posts: 512 Threads: 7 Joined: Oct 2014 Reputation: 35 12-03-2014, 02:07 AM You have to use the odbc driver. Try for the database setting string like that with your DNS name created in you windows settings: PHP Code:$db['default'] = array( ... 'hostname' => 'Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\path\to\my.mdb', // or try only the DNS name 'username' => 'dbusername', 'password' => 'dbpassword', 'database' => 'Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\path\to\my.mdb', 'dbdriver' => 'odbc', ...);  Hope this helps. jaysondotp Junior Member Posts: 36 Threads: 19 Joined: Nov 2014 Reputation: 0 12-03-2014, 06:29 PM Hi coders, Thanks to your help. I try all your suggestion but i gut this error, PHP Code: Severity: WarningMessage: odbc_pconnect(): SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnectFilename: odbc/odbc_driver.phpLine Number: 124  jaysondotp Junior Member Posts: 36 Threads: 19 Joined: Nov 2014 Reputation: 0 12-04-2014, 01:43 AM (This post was last modified: 12-04-2014, 01:44 AM by jaysondotp.) hi any body can help... i try code below but still not work and i gut error below: A Database Error Occurred Unable to connect to your database server using the provided settings. Filename: C:\wamp\www\octaon_ocs\system\database\DB_driver.php Line Number: 124 PHP Code:$active_group = 'default';$active_record = TRUE;$db['default']['hostname'] = 'Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\recent.mdb';$db['default']['username'] = '';$db['default']['password'] = '';$db['default']['database'] = 'Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\recent.mdb';$db['default']['dbdriver'] = 'odbc';$db['default']['dbprefix'] = '';$db['default']['pconnect'] = TRUE;$db['default']['db_debug'] = TRUE;$db['default']['cache_on'] = FALSE;$db['default']['cachedir'] = '';$db['default']['char_set'] = 'utf8';$db['default']['dbcollat'] = 'utf8_general_ci';$db['default']['swap_pre'] = '';$db['default']['autoinit'] = TRUE;$db['default']['stricton'] = FALSE;  jaysondotp Junior Member Posts: 36 Threads: 19 Joined: Nov 2014 Reputation: 0 12-05-2014, 01:41 AM any help..