MS SQL for User Spice?

[Angel]

Hi guys,

I'm trying to implement User Spice for a webpage that is using MS SQL to store data. I'm wondering if it is possible to use User Spice with MS SQL?

Thanks!

[mudmin]

Hi...I'm sorry I missed this question. It SHOULD be possible to use UserSpice with Ms SQL, although I haven't tried it.

UserSpice is written with all the DB connections running through PDO. The great thing about that is that PDO abstracts the database calls and essentially makes them pretty universal. That said, there might be something special that you have to do to make the initial connection. When I look at
http://php.net/manual/en/ref.pdo-dblib.php I see it talking about port numbers etc. I wonder if you just need to do a little more configuration.

[Angel]

Hi Mudmin,

Thank you very much for the reply! I'm thinking of replacing the mysqli connection in userspice with the code below. Is there anything else I need to do in order not to break anything?

$serverName = "serverName\sqlexpress"; //serverName\instanceName

// Since UID and PWD are not specified in the $connectionInfo array,
// The connection will be attempted using Windows Authentication.
$connectionInfo = array( "Database"=>"dbName");
$conn = sqlsrv_connect( $serverName, $connectionInfo);


Thanks a lot!
Angel