Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » New connection profile to Sybase ASE database..(problems)(how do I properly configure DTP to connect to Sybase ASE database?)
New connection profile to Sybase ASE database..(problems) [message #688565] Fri, 24 June 2011 23:18 Go to next message
Soapman  is currently offline Soapman Friend
Messages: 6
Registered: July 2009
Junior Member
Dear Eclipse users,

I am trying to use the Eclipse DTP to connect to a Sybase ASE database.
My driver is "Sybase XA JDBC driver for ASE 12.x"

My jar file for the connection is -> jconn3.jar

Driver class -> com.sybase.jdbc3.jdbc.SybDriver

IP -> (an IP address)
database name -> (database name)
port -> 5100

userid & password

I also give the property -> "JCONNECT_VERSION=6"


Now, I get a "successful" ping when testing the connection.
Then I connect, and it all appears to be fine.
But I've noticed that there's this "Loading Core Provider" background process running, and this takes about 20 minutes to finish (maybe about 10 processes).
(see attachment, ".png" file)

During this time, it really slows down my "Eclipse usage" and sometimes locks it up.
I have 'successfully' done a query with this, but again these processes seem to be taking forever. I've used Eclipse & DTP for other databases, like DB2, Informix, and have not had this problem.

Can anyone give me some suggestions on how to correct this?
When I use "RapidSQL" or Aqua Data Studio to connect, they connect 'automatically' and there's no slow-down (but I know they are using "Windows drivers").

My 'software' being used is:

JBoss Developer Studio 4.0.0.M2 (Eclipse 3.6.0)
Eclipse Data Tools Plugin -> 1.8.0

Any comments, help, or suggestions would be greatly appreciated!

Thanks!

J
index.php/fa/3131/0/
Re: New connection profile to Sybase ASE database..(problems) [message #690466 is a reply to message #688565] Wed, 29 June 2011 14:51 Go to previous messageGo to next message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
Messages: 495
Registered: July 2009
Senior Member
Are you connecting to an actual ASE 12.x database with the ASE 12.x driver? Or is it a newer version of the db?

Unfortunately at this point we don't have anybody supporting the Sybase support, so I don't know that we can fix this even if we discover the problem. I no longer have access to Sybase dbs.
Re: New connection profile to Sybase ASE database..(problems) [message #693231 is a reply to message #690466] Wed, 06 July 2011 04:51 Go to previous message
Soapman  is currently offline Soapman Friend
Messages: 6
Registered: July 2009
Junior Member
Yes, I am connecting to the actual Sybase ASE database 12.5.4

Again, I'm using the JDBC driver in jconn3.jar

I guess for now, I'll still use Aqua Data Studio.

Previous Topic:CSV import with auto-generated primary key
Next Topic:Network proxy settings and DTP Connections?
Goto Forum:
  


Current Time: Sun Nov 23 01:09:52 GMT 2014

Powered by FUDForum. Page generated in 0.02114 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software