I have a data table working with a remote MySQL database using:
DB type: MySQL (mysqli)
Host: {hostname}
DB name: {dbname}
User: {user}
Password: {password}

But I need to connect to a Microsoft SQL Server database. I have an ODBC datasource that works. What do I enter into Host/DB name/User/Password fields? Do I put in the ODBC data source name?

So far I only see "ARI Data Tables: Couldn't connect to external database."

Bill

Hello,

Value for "Host" parameter for MS SQL database looks like:

Driver={SQL Server Native Client 10.0};Server=localhost;Database=my_db;

Regards,
ARI Soft

Thank you.

That still doesn't work for me. What other prerequisites are there? Do I need to install and configure ODBC for PHP?

I have already successfully configured from PHP to MS SQL so sqlsrv_connect() works.

The MS SQL database is on a different server, so I'm using the name for that server instead of "localhost".

This is on a Windows Server 2012 R2, 64 bit with PHP 7.3. Also on this server I have:
* ODBC Driver 11 for SQL Server (MSODBCSQL11.DLL)
* SQL Server (SQLSRV32.DLL)
* SQL Server Native Client 11.0 (SQLNCLI11.DLL)

This is a puzzle and I think I only have one or two pieces left.

Bill

Figured it out...
* Get ODBC working from a dummy piece of PHP
* Copy the working connection string into the "Host" attribute in the "External Database" "Host" setting.