+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: odbc connection error (/showthread.php?tid=29973)
odbc connection error - El Forum - 04-27-2010
[eluser]Tamilmani[/eluser]
Hi,
I am using odbc connection. When i logged getting error message
A Database Error Occurred
Error Number: 01000
[Microsoft][SQL Server Native Client 10.0][SQL Server]Executing SQL directly; no cursor.
How i solve this issue ?
sample code database.php
$active_group = "default";
$active_record = true;
$db['default']['hostname'] = "Driver={SQL Server Native Client 10.0};Server=54.66.97.45,1433\\mssql2008-1;";
$db['default']['username'] = "username";
$db['default']['password'] = "password";
$db['default']['database'] = "databasename";
$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";
odbc connection error - El Forum - 12-05-2010
[eluser]CI_adis[/eluser]
Hi Tamilmani,
I get this error message too.. Did you manage to solve this in CI??
odbc connection error - El Forum - 02-11-2011
[eluser]CI_adis[/eluser]
unfortunately this is not fixed in 2.0... :-(