I need to connect to a remote Sybase Database using JAVA Application (JDBC). The database is located in a different location and i can ping the server using the IP. Does anyone has a code snippet which helps me to fetch the data from Sybase Database Server. I have less time to investigate, so please provide some code link or similar solution. Appreciate
IT depends which driver you are using.
I am using Jconnect.
Code to connect database for jdbc is
Properties props = new Properties();
props.put("user", "CDB_GEN"); // user id for the database
props.put("password", "proximus"); // password for the database
String url= "jdbc:sybase:Tds:<ip/host name>:<port at wich the database service is running>";
con = DriverManager.getConnection(url,props);
YOu can get the Jconnect driver from the sybase site.
and if you want to use odbc
String url = "Jdbc:Odbc:<dsn name>";
con = DriverManager.getConnection(url,<userid>, <password>);