Connect Sybase with Oracle SQL Developer

using SQL Developer to connect Sybase databases.

step 1 : open Oracle SQL Developer . click Tools Tab Next click Preferences.

step 2 : inside preferences select Database.

step 3 : inside Database “Third Party JDBC Drivers

step 4 : inside “Third Party JDBC Drivers” click Add Entry. now you have to give jdbc driver.

step 5 : for jdbc driver. in Google search box write ” jdbc driver for sybase “.

step 6 : you can find jTDS – SQL Server and Sybase JDBC driver. download driver from sourceforge.

step 7 : now click again ” Add Entry” then select jtds folder after select jtds.jar file and click OK.

step 8 : now click “New Connection” . you can see two extra tabs comes near to Oracle . 1.SQLServer 2.Sybase

step 9 : click Sybase give Connection Name = TestSybase User = userOfSybase. Password = PasswordofSybase

step 10 : now give Host Name = hostNameofSqlServer Port = 5000 and click Retrieve database.

step 11 : automatically so many database of Sybase comes. select any and click connect.

step 12 : you successfully connected SQL developer with SQL server.
Now you can use any Database and enjoy…

Post Author: adama