Trying to use the IsConnected method on an ODBCDatabase connecting to Microsoft SQL server 2016.
Tried both ‘ODBC Driver 18 for SQL Server’ and ‘ODBC Driver 17 for SQL Server’ drivers and both return IsConnected as False, never True.
Dim DBConnected = DBSelf.Connect() returns if connected or not as expected
IsConnected is going to be so handy. Having an issue at the moment where Microsoft SQL is disconnecting clients. Because I’m not connecting everytime when a query comes in I’m not detecting the DB disconnecting. IsConnected will solve this. I will submit a ticket. Also, you can’t view IsConnected in debug as it’s a method…needs to be a computed property and that method called on the backend