HELP: db-connection settings for ODBC to MSSQL

[eluser]Unknown[/eluser]
[quote author="Elminson" date="1269473410"]i use this lines to connect a remote ms Sql Server using odbc and work perfect!!!!

on database.php config

$db['default']['hostname'] = "Driver={SQL Server Native Client 10.0};Server=remote_host_name;Database=database_name;";
$db['default']['username'] = "database_user_name";
$db['default']['password'] = "database_password";
$db['default']['database'] = "database_name";
$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";

i hope this help you[/quote]


Thanks mate, this worked perfectly for me connecting to MS SQL 2008 server.

Edit: whoops, March 2 years ago, not 2 days ago.. sorry for the dig.. oh well, it was useful information for me anyway as I was having trouble figuring out how to get MS SQL working