Choc Cac

My Stuff

Comments

If you want to access the SQL Server, you can do it through dblink. You should follow the steps indicated. If you only want to connect SQL Server to SQL Developer this video can help you. https://www.youtube.com/watch?v=W1QaEHpNw6Y Regards! Choc

in Connect oracle to external data source on odbc dsn configuration Comment by Choc Cac May 23, 2019 12:30PM
Configure Heterogeneous Services Maybe you have to change the name DSN by CData 1) C:\oraclexe\app\oracle\product\11.2.0\server\hs\admin create new file: initCData.ora Inside the created file write (m) HS_FDS_CONNECT_INFO = CData HS_FDS_TRACE_LEVEL = OFF 2) C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN…

in Connect oracle to external data source on odbc dsn configuration Comment by Choc Cac May 23, 2019 11:46AM
To what external database do you want to connect? You can read about how to connect excel: https://docs.oracle.com/cd/E11882_01/owb.112/e10582/loading_ms_data.htm#WBDOD10662 if it is an external database read about "Heterogeneous Services" Regards! Choc

in Connect oracle to external data source on odbc dsn configuration Comment by Choc Cac May 22, 2019 12:29PM