How to connect to Microsoft Sql Server 2005 with PHP

[eluser]FutureKing[/eluser]
[quote author="timpisti" date="1255451681"]Hello.

You may try to this

1: Check the connection with another software in windows (like mssql management studio)
2: In most cases, the windows autentication does'nt work thru PHP.
a: Check the PHP.ini MSSQL values. You may find a point similar to: 'enable windows autentication...', or something like that. Enable it.
b: Try this
mssql_connect('SQL5.ZNETINDIA.NET') or die(mssql_get_last_message());
If you connect with windows autentication does'nt need the user and pass.

3: Create a normal SQL user - this is worked for me, and a lot of windows IT wizard can't find ANY solution to demonstrate a working MSSQL setup in this environment:

ISA server auth - Windows 2008 server - MSSQL 2008 - IIS 7.0 - PHP 5.2
Its only worked with SQL user. Not the windows authenticated.[/quote]

I tried all of the above but failed. When I tried to connect via ODBC it worked!

MS SQL 2005 -----> ODBC -------> PHP --------> Code Igniter --------> Worked!

---------------------------------------------------------------------------------------

I am creating a program which will connect to two different dbs one is new Mysql db and another is old MS Sql Server DB (via ODBC) and it will process & transfer data from MS Sql Server to MySql db.

In CI I noticed that there is option to select one db at a time in database.php file.


How to connect to two different dbs in one time with CI?