We’re trying to use mAirList with an Azure SQL DB (MSSQL).
It seems to create an initial collection and can seed the DB with the initial tables, but after that, no luck.
We currently get the following error when testing a login or any other DB related queries: "Login to the SQL server was successful, but there was an error accessing the actual database: “[FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt” If I enter invalid login details, it fails, so I know it’s at least attempting to talk to the DB.
If I paste in the full connection string provided by Azure into the Advanced field, it complains it cannot find the driver (I tried creating that file with some suggested settings from the FireDAC pages but no luck): “Driver={ODBC Driver 13 for SQL Server};Server=tcp:NAMEHEREt,1433;Database=mairlist;Uid=mairlist;Pwd=PASSWORDHERE!;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;”
Thoughts, suggestions? 
What mAirList version are we talking about? v6.x or earlier?
By the way, would you please be so kind to enter your mAirList serial No. (license number) in your profile? It’s not public, but we would like to add you to the group “verified customer”. Thank you.
Consider it done - Thanks.
This is with v6.3
This is a known issue with the default ODBC driver that comes preinstalled in Windows.
Try to install SQL Server Native Client: https://www.microsoft.com/en-US/download/details.aspx?id=50402
(Yes, 2012 is the most recent version, but it works with newer servers.)
That was it - Thanks very much. I’d tried a number of other SQL client packages but not that one, that’s done it
1 Like
@Torben We are occasionally seeing the following. I’m struggling to re-produce at the momment but we see this occasionally in the API logs. This is just with API usage, I’m a little concerned we’ll see similar when we start loading in schedules and running playout.
10.0.0.4 - "apiuser" [05/Jun/2020:17:57:51 +0100] "GET /api/v1/folders HTTP/1.1" 200 - "-" "GuzzleHttp/6.5.4 curl/7.64.0 PHP/7.4.6"
[FireDAC][Phys][ODBC][Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host.
10.0.0.4 - "apiuser" [05/Jun/2020:18:36:10 +0100] "GET /api/v1/folders HTTP/1.1" 500 - "-" "GuzzleHttp/6.5.4 curl/7.64.0 PHP/7.4.6"
[FireDAC][Phys][ODBC][Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host.
10.0.0.4 - "apiuser" [06/Jun/2020:09:21:32 +0100] "GET /api/v1/folders HTTP/1.1" 200 - "-" "GuzzleHttp/6.5.4 curl/7.64.0 PHP/7.4.6"
10.0.0.4 - "apiuser" [06/Jun/2020:10:25:00 +0100] "GET /api/v1/folders HTTP/1.1" 200 - "-" "GuzzleHttp/6.5.4 curl/7.64.0 PHP/7.4.6"
[FireDAC][Phys][ODBC][Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host.
10.0.0.4 - "apiuser" [06/Jun/2020:10:54:10 +0100] "GET /api/v1/folders HTTP/1.1" 500 - "-" "GuzzleHttp/6.5.4 curl/7.64.0 PHP/7.4.6"
[FireDAC][Phys][ODBC][Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host.
10.0.0.4 - "apiuser" [06/Jun/2020:10:54:41 +0100] "GET /api/v1/folders HTTP/1.1" 200 - "-" "GuzzleHttp/6.5.4 curl/7.64.0 PHP/7.4.6"
mAirList uses a persistent SQL connection to the server (this may change in the future). It appears to be some sort of timeout that you run into if the connection is idle for too long?