hi i would like to buy your dashboard builder and i need to know if i can connect my Microsoft SQL DB that is hosted on a other server , is it posabile to do it ? regards
Yes, you can connect to the MS SQL Server database. You need to enable PDO_SQLSRV on the hosting server and give remote access of your MS SQL server to the host where you have installed the DashbaordBuidler to connect to the SQL Server.
• Download and run the installation package from https://github.com/microsoft/msphpsql • Enter a directory to extract the package into when prompted. • Open the directory and copy the required dll libraries to your PHP extension directory. The filenames indicate which PHP version, threadedness, and architecture each dll file is • Edit your php.ini file to add the following lines in the Extensions section: Extension=php_sqlsrv.dll • Start your Wamp server