There is no issues with the gateway and I can ATM read all SQL Server tables/views fine, but the only way I can connect to the database is via SQL Plus or via APEX, not through SQL Developer or through BI Publisher (JDBC).
I have tnsping'ed both XE and dg4msql and both came up as ok.
My JDBC connection String in BI Publisher is: jdbc:oracle:thin:@AA-PC:1521:XE
The error I got was:
Could not establish connection.
Would be great if someone can point out how I can connect to my Database without switching off the dg4msql listener. Cheers.