Welcome Guest, Not a member yet? Register   Sign In
Codeignter querying mssql through odbc
#1

[eluser]flaky[/eluser]
Hi guys. I'm having this little issue

I'm connecting to mssql using odbc.
Code:
$db['default']['hostname'] = "Driver={SQL Server Native Client 10.0};Server=FLAKRON-PC\SQL2008;Database=test;";
$db['default']['username'] = "sa";
$db['default']['password'] = "sa";
$db['default']['database'] = "test";
$db['default']['dbdriver'] = "odbc";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = FALSE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";

it's connecting without problems. The issue is when I query a table e.g tbl_user.
Active record is querying it with this sql
Code:
SELECT * FROM (tbl_user)
which is wrong, the sql syntax will fail, how can I remove the brackets around the table name?

cheers


Messages In This Thread
Codeignter querying mssql through odbc - by El Forum - 05-05-2010, 02:57 AM
Codeignter querying mssql through odbc - by El Forum - 05-05-2010, 03:35 AM
Codeignter querying mssql through odbc - by El Forum - 05-05-2010, 04:28 AM
Codeignter querying mssql through odbc - by El Forum - 05-05-2010, 04:37 AM
Codeignter querying mssql through odbc - by El Forum - 05-05-2010, 06:54 PM
Codeignter querying mssql through odbc - by El Forum - 05-05-2010, 11:42 PM
Codeignter querying mssql through odbc - by El Forum - 05-06-2010, 06:37 AM
Codeignter querying mssql through odbc - by El Forum - 05-06-2010, 08:29 AM
Codeignter querying mssql through odbc - by El Forum - 05-06-2010, 07:34 PM
Codeignter querying mssql through odbc - by El Forum - 05-06-2010, 11:38 PM
Codeignter querying mssql through odbc - by El Forum - 05-11-2010, 12:29 AM
Codeignter querying mssql through odbc - by El Forum - 05-12-2010, 03:22 AM
Codeignter querying mssql through odbc - by El Forum - 05-13-2010, 05:24 AM
Codeignter querying mssql through odbc - by El Forum - 05-16-2010, 11:18 PM



Theme © iAndrew 2016 - Forum software by © MyBB