connect to Wonderware Historian OLE DB using python 3 and OSX or Linux

Could anyone share a functional connection method to Wonderware's Historian using python3 on OSX (or linux)?

Historian is apparently a Microsoft SQL Server OLE DB (see pg102 of http://www.logic-control.com/datasheets/1/Historian/HistorianConcepts.pdf).

Another SO post suggests that the only python library available capable of connecting to an OLE DB is 'adodbapi' (Connecting to Microsoft SQL server using Python)

an attempt in code (using default RO credentials):

import adodbapi
ServerName = "ServerName"
MSQLDatabase = "Runtime"
username = "aaUser"
password = "pwUser"
conn = adodbapi.connect("PROVIDER=INSQL;Data Source={0};Database={1};trusted_connection=yes;UID={2};PWD{3};".format(ServerName,MSQLDatabase,username,password))

That gives an error:

adodbapi.apibase.OperationalError: (InterfaceError("Windows COM Error: Dispatch('ADODB.Connection') failed.",)...

The error is probably due to the absence and unavailability of the pywin32 package, which is apparently Windows only (Pywin32 (com objects) on Mac)

Tips appreciated. I highly suspect that the Microsoft vs Mac/Linux worlds just can't be bridged in this situation.

You should be able to access an MS SQL Server database (e.g. Wonderware Historian database) with Python.

Things to check:

• For ODBC, "Trusted Connection" setting should be "No". Trusted connection means that it tries to use Windows Authentication to log in. You want to use a username and password instead. I think for OLE DB you set "Integrated Security = SSPI" instead.
• Connection String (Username, Server Hostname/IP, Database name, Correct Port, Syntax)
• Port (make sure you use the correct port - may be a non-standard port)
• Firewalls - make sure that any firewalls are set up to allow access
• If you're using the hostname, make sure DNS is working (e.g. can you ping the server?)
• You may need to install an ODBC driver for Linux and pyodbc. ODBC is a more open standard. As you've pointed out, OLEDB is COM-based (e.g. Windows-based) so I'm not sure if it would be compatible.