php connection to MSSQL Server 2008

[Behzadsh]

hi,

I'm a php programmer, Formerly I worked with mysql and I have no problem. In a new project I should work with MSSQL server DataBase.
My problem is that I'm programming in linux platform (ubuntu lucid), so I run windows 7 on vitualbox, Install SQL Server, Create a Host-Only Network from ubuntu to windows 7, but I couldn't connect to SQL SERVER through php. Now I don't know what should i do...

[ixalmida]

I had a heck of a time trying to connect to MSSQL from Linux. It can be done, but the only driver I've found that works properly with the latest versions of MSSQL is the Easysoft driver. Assuming you don't want to spend the $1,200 for that, it is best to connect via Windows, which has built-in MSSQL connectivity. Then it's a simple matter of ensuring that the MSSQL extension is installed and enabled (which it is by default in the XAMPP package).

After that, everything gets very easy and MySQL-like:

$conn = mssql_connect("servername", "username", "password");