Friday, January 22, 2010

Connect Sql Server in SqlDeveloper Tool

1) download net.sourceforge.jtds.jdbc.Driver
http://sourceforge.net/projects/jtds/files/jtds/1.2.1/jtds-1.2.1-src.zip/download

2) In Oracle SQL Developer open Tools -> Preferences Database -> Third Party JDBC Drivers
Add Entry
Browse the unzipped driver and add the jtds-1.2.jar file

3) Error
I/O Error SSO failed Native SSPI library not loaded
check the java.library.path.system property


Copy the file 'jtds-1.2.2-dist\x86\SSO\ntlmauth.dll' from the unzipped JTDS --> \jdk\jre\bin.


4) Then restart SQL Developer.

No comments:

Post a Comment

Followers