ServerSide Post Data MSSQL with ODBC13 System DSN

acidburn78

Hello All,

i'm using ServerSide Post Data and i would like to use the SYSTEM DSN with ODBC13 driver!

Now i'm using this as sql_details

// SQL server connection information
$sql_details = array(
    'user' => '',
    'pass' => '',
    'db'   => '',
    'host' => ''
);

in the PDO-Connection String it should be looking like this
new PDO ( "odbc:<DSN_Name>", 'user', 'pass')

How can i set the DSN in the sql_details that the PDO-Connection and the rest in ssp.class.php will work?

allan

The demo SSP class is MySQL specific. You would need to modify the DSN in the file as you mention, but there is a good chance you might also need to modify the SQL that it generates to have it work with SQL Server.

Allan