morty Install MS SQL Server extension for PHP

[Ookma-Kyi]

Could you please install the MS SQL Server extensions for PHP? The files needed are:

php_pdo_sqlsrv_xx_ts.dll and php_sqlsrv_xx_ts.dll (where xx represents your PHP version) into your PHP's ext directory.

Thanks

[MoneyBroz]

This support request is being escalated to our root admins.

[MoneyBroz]

10 minutes ago, Ookma-Kyi said:

php_pdo_sqlsrv_xx_ts.dll and php_sqlsrv_xx_ts.dll (where xx represents your PHP version) into your PHP's ext directory

This likely won't work as Johnny, Tommy, and Morty run on Linux instead of Windows but I'll escalate it anyway and see what a root admin has to say about it. Lily would be the only server that this would likely work on.

[Ookma-Kyi]

22 minutes ago, MoneyBroz said:

This likely won't work as Johnny, Tommy, and Morty run on Linux instead of Windows but I'll escalate it anyway and see what a root admin has to say about it. Lily would be the only server that this would likely work on.

Sorry totally forgot my dev machine is running a different OS. Here are updated instructions from Google AI:

 

To install the php_pdo_sqlsrv 82_ts extension for PHP 8.2 on Linux, you need to install the Microsoft ODBC Driver, the unixodbc-dev package, and then compile and install the extension using PECL. The specific commands for installing prerequisites may vary by distribution, and you will need to use pecl to install the driver, ensuring the PHP version and threadedness (TS for Thread Safe, NTS for Non-Thread Safe) match your environment. 
Step 1: Install prerequisites
Install Microsoft ODBC Driver: Follow the official Microsoft instructions for installing the Microsoft ODBC Driver for SQL Server on Linux.
Install build tools and unixodbc-dev:
For Debian/Ubuntu:
bash
sudo apt-get install build-essential unixodbc-dev
For CentOS/AlmaLinux/RHEL:
bash
sudo yum install make gcc-c++ gcc autoconf automake libtool-ltdl-devel
Install PHP development files: Make sure you have the development files for your specific PHP version.
For Debian/Ubuntu:
bash
sudo apt-get install php8.2-dev
For CentOS/AlmaLinux/RHEL:
bash
sudo yum install plesk-php82-devel # Or the appropriate package for your system
 
Step 2: Install the PDO_SQLSRV driver 
Use PECL to install the extension:
bash
sudo pecl install pdo_sqlsrv
Enable the extension:
Create a new .ini file in the PHP extensions directory (e.g., /etc/php/8.2/mods-available/pdo_sqlsrv.ini).
Add the following line to the file, ensuring the filename matches your system's needs:
ini
extension=pdo_sqlsrv.so
Enable the module:
bash
sudo phpenmod -v 8.2 pdo_sqlsrv
Restart your web server:
For example, for Apache: sudo systemctl restart apache2 
Step 3: Verify the installation 
Create a phpinfo() file in your web server's document root and access it through a web browser.
Search for pdo_sqlsrv to confirm that the extension is loaded correctly. 

Edited 2 hours ago by Ookma-Kyi

[Krydos]

Which MS SQL database are you planning on connecting to?

[Ookma-Kyi]

17 minutes ago, Krydos said:

Which MS SQL database are you planning on connecting to?

@wolstech I would like a MS SQL Express account please.

Edited 1 hour ago by Ookma-Kyi

[wolstech]

You have to have a Lily account to use MSSQL.

If I remember correctly, you previously had me delete your Lily account, or if it still exists I don’t know what the username is.

[Ookma-Kyi]

17 minutes ago, wolstech said:

You have to have a Lily account to use MSSQL.

If I remember correctly, you previously had me delete your Lily account, or if it still exists I don’t know what the username is.

Yes it was deleted because I was no longer running a .Net app. I try to not waste resources as much as possible. Is it possible to open a Lily account without running a .Net app?

Edited 41 minutes ago by Ookma-Kyi

[MoneyBroz]

40 minutes ago, Ookma-Kyi said:

Yes it was deleted because I was no longer running a .Net app. I try to not waste resources as much as possible. Is it possible to open a Lily account without running a .Net app?

Yes