How to connect to Microsoft Sql Server 2005 with PHP

[eluser]jadfreak[/eluser]
[quote author="FutureKing" date="1256218829"][quote author="Moisés" date="1255988095"]How did you resolve your problem FutureKing? I'm trying to connect to a MSSQL 2005 server through ODBC connector but I can't [/quote]

I used ODBC connector. Create ODBC connection from Administrative tools on your computer.

Fill your db config something like this:


$db['sqlserver']['hostname'] = "mydatabase";
$db['sqlserver']['username'] = "";
$db['sqlserver']['password'] = "";
$db['sqlserver']['database'] = "";
$db['sqlserver']['dbdriver'] = "odbc";
$db['sqlserver']['dbprefix'] = "";
$db['sqlserver']['pconnect'] = TRUE;
$db['sqlserver']['db_debug'] = TRUE;
$db['sqlserver']['cache_on'] = FALSE;
$db['sqlserver']['cachedir'] = "";
$db['sqlserver']['char_set'] = "utf8";
$db['sqlserver']['dbcollat'] = "utf8_general_ci";[/quote]


hello futureking..

can you provide us with a more complete code for your solution above. i can't seem to make it work. please..