Solved

Oracle HS to SQL Server via JDBC

Posted on 2014-03-24
3
378 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-
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 48

Accepted Solution

by:
PortletPaul earned 500 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What type of testing am I doing? 4 76
SQL Server how to use a VARIABLE to link tables in a SQL Script? 3 41
Powershell error using sql agent job 24 41
SQL Server Pivot 5 42
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

751 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