New answers tagged odbc
I would check if you have "Quoted Identifiers" set in the DSN, it looks like its interpreting [Sat. Current] as the column [Current] in the table [Sat]
You should be able to get away with this by creating views in SQL Server that are effectively wrappers for tables in the linked server. You will of course have to deal with the extra layer of security configuration for the linked server, thus ensuring that the Access users are connecting to the external data with the proper credentials (whether it be ...
You can pull cx_Oracle from anaconda.org I can verify that these packages have worked for me in the past: https://anaconda.org/trent/cx_oracle [linux-64] https://anaconda.org/trent/cx_oracle-11g [win]
Top 50 recent answers are included