I was wondering if anyone knew where I could go to for some help setting up a PHP site to access a MS SQL Server database.
I'm working on a project that's running a php site on the raspberry pi and I have been connecting back to a MySQL database which works lovely, except ultimately I need to push data back to a MS SQL Server database.
I'm able to transfer the data over from the MySQL to the SQL Server database but I was wondering about cutting out the middle man and connecting straight to the SQL Server database from my PHP website.
This is where I've got struck, any help on how I set up the access from RaspberryPi so that a PHP page can run SQL against the MS SQL Database. I guess I need to install some ODBC drivers?
Any help pointers would be very much appreciated as currently quite stuck as every search I do just seems to either tells me how to set up MySQL or how to set up Python to access MS SQL Server.