MS Query Mac vs PC and exchanging spreadsheets

Hello,

We have a couple of Macs in our organization which have Office for the Mac
installed, and we were looking for ways to use MS Query for the mac, to run
reports against an Oracle database. We found we needed to use a 3rd party
ODBC driver (from Actual Technologies) to accomplish this, and were able to
get it to work.

What we've found, however, is a query in a spreadsheet that was generated in
Excel for Mac, cannot be edited nor refreshed when sent to a Windows Excel
user - even if both machines have the same DSN names setup for ODBC.

When attempting to edit/refresh a query we get:


[Microsoft][ODBC Driver Manager]Data source name not found...

At this point, we can select a datasource (that matches the same DSN name
that was used to create it, on the Mac) but then we receive:

[Microsoft][ODBC Driver Manager] Drier's SQLSetConnectAttr failed
[Microsoft][ODBC Driver for Oracle] Invalid connection string attribute

This this mean that the connection string formats used on the Mac, and
Windows, are different (and thus incompatible)?

Thank you for any insight.. or if a different Mac ODBC driver is recommended!

Maurice