Connect to external database with PDO_DBLIB

[sandormatyas]

There is a Joomla 3.10.6 site and need to connect to an external MSSQL database via PDO_DBLIB and fetch some data
I usually use something like this for external databases
$option['driver'] = 'mysqli';
$option['host'] = 'remote.host';
$option['user'] = 'username';
$option['password'] = 'password';
$option['database'] = 'dbname';
$option['prefix'] = '';

but what about pdo_dblib?
I can find dblib in FOFDatabaseDriverPdo buthing more. Should I need to build my own FOFDatabaseDriverPdodblib class extending pdo? Or is there something already?

[smartestlancer]

Hey,
Did you check the Joomla documentation for this?

https://docs.joomla.org/Connecting_to_a ... l_database

Let us know if this guide helps you!

Thanks

[Per Yngve Berg]

MSSQL database support is dropped from Joomla.

You can use the php functions. The server needs to have the php libraries for MSSQL database installed.

https://www.php.net/manual/en/function. ... t-info.php