?
Solved

Oracle HS to SQL Server via JDBC

Posted on 2014-03-24
3
Medium Priority
?
391 Views
Last Modified: 2014-05-21
Is connection to a remote SQL server DB possible using JDBC vs ODBC?

If so, does anyone know a good place to start research?

Thanks
0
Comment
Question by:FutureDBA-
2 Comments
 
LVL 49

Accepted Solution

by:
PortletPaul earned 2000 total points
ID: 39952571
Can you use JDBC to connect to a SQL Server database? = Yes.

Microsoft provide their own
(eg http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx )  
or you can find other JDBC providers that support SQL Server
(eg http://www.datadirect.com/products/datadirect-connect/jdbc-drivers)

Could you narrow down what topics you want to research?
0
 

Author Comment

by:FutureDBA-
ID: 39965709
What I am trying to do is pretty straight forward with Oracle Database Gateway and ODBC, i figured since this is an oracle product, the placement of the post was valid. However, if you think otherwise is best, we can go with your setup.

What I am trying to do is create a public (or private) database link from within oracle to a remote SQL server, have link be created with JDBC instead of ODBC
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question