IS there an exmple of how to create a TAurelius Connection for DevART SDAC SQL Server Data Access Components ?
Devart is supported with UniDAC. Variations of that product (ODAC, SDAC, IBDAC) are not officially supported but can be used by small manual modifications of our UniDAC driver (mostly changing the name of components).
It was done for IBDAC in this support topic, likely it can be adapted for SDAC as well:
Hi yes I have tried this. However I am getting this error: First chance exception at $00007FFDD5F01ADA. Exception class EOLEDBError with message
'OLE DB error occurred. Code 800401F0h.
CoInitialize has not been called.'.
Process CoyoteRemoteDB.exe (32572)
Here is the SDAC Adapter code. CoyoteRemoteDB works with FireDAC. But FireDAC is much slower than SDAC.
AureliusSDAC.zip (9.2 KB)
CoInitialize is a COM issue. If SDAC doesn't handle it, you should do it yourself, making sure it's called in which thread a database connection is needed.
You can use this approach to initialize COM in every request received by RemoteDB. The example is using XData but it's the same with RemoteDB: