Login

03-08-2012, 03:52 AM

[eluser]sunil shrestha[/eluser]
I have also connect codeigniter and odbc using DSN Name. But there is some bugs with this driver while using ACTIVE RECORDS.... You should hard code the sql query. for example.. using active records for odbc, it add the bracket to the table name which is not executed for MS sql server. It shows errors like below:
A Database Error Occurred

Error Number: 37000

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.

SELECT * FROM (ci_sessions) WHERE session_id = '3ad914bb5f5728e8ac69ad1db8fc9841' AND user_agent = 'Mozilla/5.0 (Windows NT 6.1; rv:10.0.2) Gecko/20100101 Firefox/10.0.2'

Filename: D:\wamp\www\IVR_Panel\system\database\DB_driver.php

Line Number: 330

The following are the config file for connecting odbc for MS SQL SERVER

Code:
$db['default']['hostname'] = 'IVR';   // DSN Name created in odbc of administrative tools of // controll panel

$db['default']['username'] = 'dbusername';   // user name of database

$db['default']['password'] = 'dbpassword';   //password of database

$db['default']['database'] = 'dbname';       // database name to connect

$db['default']['dbdriver'] = 'odbc';         // odbc driver name

$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;

above config is enough to connect to odbc but you have creaTE THE dsn in odbc of administrative tool of control panel