Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2535
  • Last Modified:

Oracle SQL Developer 4.0.1.14 settings for jdbc access to MS SQL server

Hi Expert,

In my old laptop, I used Oracle SQL Developer version 3.0.04.34+ JTDS driver version .  I was able to connect to MS SQL server by pointing to the driver from setting of "TOOL - PREFERENCE - DATABASE - THIRD PARTY JDBC DRIVERS"

of course, I put JTDS driver in that folder (jtds-1.2.5.jar)

With the new PC, I just installed Oracle SQL Developer 4.0.1.14 and tried to mimic the same setting. By putting JTDS driver version "jtds-1.3.1.jar" in to the folder

But nothing happen !!

 When I try to create NEW Connection, I expect to see a tab for "SQLServers" to set access to those server. But it shows only "Oracle" and "Access" tab

Help Please.
0
Paul_ATL
Asked:
Paul_ATL
  • 3
  • 3
1 Solution
 
b_levittCommented:
You need to download the 1.3.1 version of jtds.  I just tried it myself and it worked fine (didn't even require a restart).

http://sourceforge.net/projects/jtds/files/
0
 
Paul_ATLAuthor Commented:
Hi b_levitt,

Can you elaborated on the steps after download "jtds-1.3.1.jar" please. As mentioned, I put it in one of the folder and point "TOOL - PREFERENCE - DATABASE - THIRD PARTY JDBC DRIVERS" to it.

But then in the NEW DB Connection setup, it does not show any choice for MS SQL.
0
 
b_levittCommented:
What you describe is all I did:

New JDBC
SQL Tab
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
Paul_ATLAuthor Commented:
I notice in your set up, you are able to show the jar file, whereas in my case, it only point to the folder where the jar file is stored

Any idea ?
0
 
b_levittCommented:
It shows the jar file as a folder when you are browsing for the location:

jar folder
0
 
Paul_ATLAuthor Commented:
This is very strange, when it was not working, I did
- unzipped the files/folders as a subfolder to my other one that I user long name
- such as \document\sqldeveloper\jtds files\
- I did tried put it under shorter name without success, i.e., C:\jtds\    

but when looking at folder name of b-levitte, I did again unzipped it to the exact name, i.e., C:\jtds-1.3.1-dist\

like magic . . . it works !!!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now