I'm encountering an issue while trying to connect to a SQL Server database using PHP Laravel on macOS with Brew. I'm receiving the following error message: [Microsoft][ODBC Driver 17 for SQL Server] SSL Provider: [error:0A000102:SSL routines::unsupported protocol] Checked this GitHub…
using ubuntu 22, php8.2, odbc driver 18, OpenSSL 3.0.2, when I try to connect with a sqlsrv database using pdo_sqlsrv, it return me this error: SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate] the code…
I'd like to make a sql table something like this. I want to insert 80 data records in my SQL databse with the same ID number. How can i overcome this sql database?
I am trying to execute a stored procedure which inputs data to my database. I am setting up my parameters as follows: ($conn has my db creds, $xml contains data from an XML file) $params = array( array($xml->filenumber, SQLSRV_PARAM_IN, SQLSRV_SQLTYPE_VARCHAR(20)),…
This had been working up until a few days ago. We are building a docker container with the following code, but this is the error that happens when trying to "pecl install sqlsrv". Trying to connect to mssql server from…
In my case, I have three tables: type id type reason_id reason id reason permission id type_id reason_id (not sure has or not) I expect that: { "message": "Get all permissions with type and reason", "data": [ { "id": "1",…
I have successfully installed PHP 8.2 on Ubuntu 20.04. I am trying to add the SQLSRV extension following these directions. The installation for SQLSRV completes successfully. However, when I try to run a function in PHP using SQLSRV extension, I…
I'm using the following PHP connection file to connect to my SQL Server database. <?php $servername = "..."; $username = "..."; $password = ""; $dbname = "..."; try { $conn = new PDO("sqlsrv:Server=$servername;Database=$dbname", $username, $password); echo "Connected to $dbname at…
After upgrade to php 8.1 (Linux PHP) , Azure webapp does not seems to have driver for MS SQL. It was OK with php 7.4. Following this guide (https://learn.microsoft.com/en-us/azure/app-service/deploy-local-git?tabs=cli), steps to build and configure Azure App service was: az appservice…
first of all, im really noob.(sorry for that) secondly, iam trying to connect php to mssql server. thirdly, i already install sqlsrv, pdo_sqlsrv, and msodbcsql.msi but still get error message when trying to connect my php version is 8.0.10, x64;…