DSN for MS SQL Server Express 2005 in PHP

Question

I'm trying to connect to a MS SQL Server Express 2005 using PDO for ODBC, but I need the DSN string. I tried with:

$dsn = 'odbc:DRIVER={SQL Server};HOSTNAME=CCTPV608SQLEXPRESS;DATABASE=db_ibripos';

but it doesn't work, please help.

Answer 1

Have you tried this

http://php.net/manual/de/ref.pdo-dblib.php#66917

Comments

Thanks, I found it:

$dsn = 'odbc:Driver=SQL Server;Server= CCTPV608SQLEXPRESS;Database=db_ibripos';