We're trying to use pyodbc to connect to an ODBC connection that's correctly configured through Win10's OBDBC Data Source Administrator (32-bit), but the driver is "SPAN Open ODBC", a string we ironically can't find anywhere on the internet.
pyodbc throws "pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (Sified (0) (SQLDriverConnect)')", and when we check [print(x) for x in pyodbc.drivers()], "SPAN Open ODBC" is indeed absent.
We've found the DLL the Win ODBC Administrator uses at C:\Windows\SysWOW64\dhodbc.dll, but don't know how / if we should pass this to pyodbc. The company Win10 ODBC Administrator lists for it is "Dharma Systems", and the only docs we can find are from 1999...
I know this isn't much to work with but we're grasping at straws here. Do we have any options?