+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Connection to Access (/showthread.php?tid=429)
Connection to Access - jaysondotp - 12-02-2014
Hi Coders,
any body can help, how to connect CI.3 to access 97
RE: Connection to Access - sv3tli0 - 12-03-2014
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/178860/how-do-i-add-an-msaccess-connection-to-codeigniter-or-cakephp
RE: Connection to Access - Rufnex - 12-03-2014
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.
RE: Connection to Access - jaysondotp - 12-03-2014
Hi coders, Thanks to your help.
I try all your suggestion but i gut this error,
PHP Code:
Severity: Warning
Message: odbc_pconnect(): SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect
Filename: odbc/odbc_driver.php
Line Number: 124
RE: Connection to Access - jaysondotp - 12-04-2014
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;
RE: Connection to Access - jaysondotp - 12-05-2014
any help..