A connector in a legacy system is working find under DMA 8.5. It runs a query on an external SQL database using the following c# code inside a QAction:
SLConnectionManager manager = new SLConnectionManager();
SLSql db = manager.GetConnection(connInfo.type, connInfo.connectionString);
ds = db.Query(sQuery);
db.Close();
However the same code running inside another DMA running 9.6 or 10.0 and the db object is not created and the Query exceptions out with no object.
I'm wondering if these kinds of db connections have been deprecated and if so which classes should be used?
Hey Cyrus, what connInfo.type is being passed in? As far as I see, the only way to have manager.GetConnection(string type, string connectionstring) return null is an invalid connection type.
As this question has been inactive for a long time, we will now close it. If you still want further information, could you post a new question?