I am trying to enable sqlsrv drivers for php8.1 on Ubuntu 20.0. It is not showing the extension in phpinfo(). When trying to check the sqlsrv module with commmand php -m, the output is like this: ...

While installing sqlsrv module for PHP7 i'm getting following error - No releases available for package "pecl.php.net/sqlsrv Command used sudo pecl install sqlsrv Any idea how to resolve...

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 ...

developer! I'm using Laravel framework and I need to connect to MS SQL 2014 Express database. I've made all the proper configurations in .env (and I even tried tried to put connection parameters s...

I'm trying to use a docker image with Laravel + Microsoft SQL drivers. My dockerfile: FROM php:7.2-apache ENV ACCEPT_EULA=Y # Microsoft SQL Server Prerequisites RUN apt-get update \ && c...

I run SQL Server 2016. I try to connect to it via a PHP script (PHP version 8). I did install the drivers and added the path in the php.ini (same version as my PHP version): ... extension=pdo_sqlsr...

I've looked over several other questions that seem (from the titles) the same as this. However, my case is a bit different. The following works (i.e. I get "success" and my database performs what ...

I can't seem to figure out why sqlsrv_fetch_assoc only returns 1 row when there are 2 rows in the result set according to sqlsrv_num_rows. I've tried to hard code the parameter, but I still get the...

I am migrated from MySQL to MS SQL Server, and trying to fetch all data from the routines table. I am connected but unsure how to fetch data with sqlsrv. This is how far I have came: $conn_array =...

I am using sqlsrv database connection in my project as I need to connect to Microsoft SQL Database. I have successfully installed the sqlsrv driver because I can connect to the Database to retriev...

I have a laravel application that connect a sql server db on Azure. On my local Wamp server the application works. I have installed on my linux server using a docker image, and don't connect the Az...

I tried to call a SQL Server stored procedure from PHP. Here is my stored procedure: CREATE procedure [dbo].[tester] @id NVARCHAR(MAX) AS BEGIN DECLARE @tab TABLE (myxml XML) INSERT INTO @tab...

I'm trying to get a connection to MS SQL up and running via PHP on my machine. I'm running IIS, have PHP 7.2 installed and MS SQL Express 2017. I have my basic web page running but when I click to ...

I'm trying to install sqlsrv by using the commands from this page. However, when running pecl install sqlsrv-4.2.0preview I get the error: Error 1 ERROR: 'make' failed. I tried : apt-get upda...

Here is my setup Windows Server 2008 R2 64 bit Apache 2.4.4 64 bit PHP 5.4.15 32 bit (64 bit is still experimental), thread safe, VC9 compiler Microsoft SQL Server 2012 Native Client 64-bit Micro...

I want to access the MS SQL Server and have the select query. I have installed the dll files and am using the sqlsrv_query. The connection has been successful but I get: [Microsoft][SQL Server N...

SQLSRV is the only driver for PHP that is capable of storing UTF-8 strings into two-byte columns (NVARCHAR instead of VARCHAR) which is currently maintained and supported by Microsoft for PHP 5.2.X...

I'm attempting to setup the Microsoft ODBC Driver on platform.sh so that the PDO_SQLSRV and SQLSRV PHP extensions are available to me. apt and other sudo commands are limited. However, during the b...

I searched all day to find out a solution for sqlsrv dll on php 7 VC14 x64 Thread Safe and i did not found a solution. Does anyone solved this issue : [04-Oct-2015 19:48:05 UTC] PHP Warning: PHP S...

we switched our DB connection from ADODB to SQLSRV and I seem to have issues with it causing intermitent delays using sqlsrv_fetch_array. I do a query in my database that returns around 426 rows w...

With MySQL I can use $pdo->setAttribute(PDO::ATTR_TIMEOUT, 5); to set connection timeout value. But when I'm using sqlsrv driver, it's working different. Can you explain how to set connection...

I have a Stored Procedured which creates a temporary table (#test), fills it with data from another table, runs 3 selects on this temporal table and drops it. The original table it's over 20 GBs b...

I am trying to get the number of rows returned in a query. The while loop looping through the results works, but for some reason the sqlsrv_num_rows does not return any value: $result = "SELECT * ...

Working on creating a CSV file and wondering how I can get the column name in the first row. Right now I think it's trying to echo the Column name but getting 0'nulls. I am also wondering if it's p...

This does not work: $dbh = new PDO("dblib:host=xxxx;dbname=xxx", "xxxxx", "xxxxx"); $sth = $dbh->prepare("{exec wcweb_UserInfo(?)}"); $sth->bindParam(1, $name); $sth->execute(); wh...