DirectQuery to ORACLE

[IanCockcroft]

Hi guys, 

I'm trying to connect to an ORACLE source using DirectQuery but getting an error.

I can connect using IMPORT mode.

I am using the TNS ODAC connection through ODBC

any idea why and how to fix it?

thanks a mil

[amitchandak]

@IanCockcroft , Make sure you have to install the Oracle driver and added the install folder on the windows path. If needed add tns entry in tnsname.ora

make sure you follow topic description steps

[IanCockcroft]

Thanks for looking Amit.

why can I connect using IMPORT mode?