Thanks so much. It just does not work for me. I can't find a place in Access where I can paste in the connection string. I found a workaround by connecting to the table in the unit catalog via Excel and then linking the Excel table in Access. Ugly bu...
I think in ms access one can only connect using simba ui. Which is successful but I can only see.the hive meta_store. How can I get ms access to point to a different catalog? With the same dsn in excel i can see all the catslogs. Please help? Thanks ...
I have the same issue as well. The odbc connection works fine in excel but when I use it with ms access all I can see is the hive_metastore. Has anyone here found a solution? @Brammer88 did you resolve your issue? If you found a solution I'd really a...