S.O.S SyBase Connection

[Marty]

Hi guys,
From sybase webpage I've downloaded a jconn3.jar file, I'm trying to connect from a class and I can't!
Please if someone of you have the sentence of connection to the sybase,Can you send me??? is very urgent
I do not want to use DNS (ODBC), they have said to me that I have to do an odbc ... I want to connect directly, thank you for everything.
PD. The base of information is remote. Name of the server: MED and his(her,your) ip is: 10.1.1.82,7000

[pegitha]

This does not work for you?
Connection connection = DriverManager.getConnection(url, username, password);
with the URL being something like:

Code:

String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber
					+ ":" + sid;

expect of course with the string needed for sybase (as I am using oracle).

[Freddie]

Hi Marty:
I connect to Sybase with java, and wue use DBVisualizer, and
Squirrel-sql. as a clients
There are 2 types of server in sybase:
1 - Sybase Adaptive Server Anywhere
2 - Sybase Adaptive Server Enterprise

The url format is different in 1 and 2.
You have to find what type is your server

I give you some url so you try:
type one:
format:

jdbc:sybase:Tds:<host>:<port>?ServiceName=<DBNAME>

example:

jdbc:sybase:Tds:endeavor.mcilink.com:10000?Service Name=TEST40_SQL


type 2:
format:

jdbc:sybase:Tds:<host>:<port>/<DBNAME>

example:

jdbc:sybase:Tds:kenobi2:10010/tsbd_dca


ah! You have to provide the user and pass

good luck