RE: [PHP] MS SQL server connection problem.

[Andrew Ballard]

On Sep 5, 2012 7:14 AM, "Jeff Burcher" <j...@allredmetal.com> wrote:
>
> Hi,
>
> I am relatively new as well. I tried both of those methods with no luck. I
> finally had success using odbc_connect(). See below:
>
> $conn = odbc_connect("Driver={SQL
> Server};Server=$server;Database=$database;", $user, $password);
>
> Thanks,
>
> Jeff Burcher - IT Dept

ODBC may work for you, but it has issues if you need to work with text
longer than 4k if I recall.

The SQLSRV library really is the way to go. Just make sure you have the
correct SQL client library installed and use the SQL for PHP driver that
matches your PHP installation. (Threaded, non-threaded, etc.)

Andrew