Paul_ATL
asked on
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.
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.
ASKER
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.
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.
What you describe is all I did:
ASKER
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 ?
Any idea ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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\jtd
- 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 !!!
- unzipped the files/folders as a subfolder to my other one that I user long name
- such as \document\sqldeveloper\jtd
- 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 !!!
http://sourceforge.net/projects/jtds/files/