Sybase and ODBC

Hello,


Was the ODBC connections removed from the latest versions (I'm using version 142.2976 (Natasha)) ?
I was using 0xDBE to connect to a distant Sybase database with a local ODBC connection.

Bye,
Hervé

6 comments
Comment actions Permalink

Hello Hervé,

What Datasource and driver jar library do you use to connect to a Database? You should be able to connect to a any database for which driver jar exists using generic Database Driver https://www.jetbrains.com/idea/help/managing-data-sources.html#d340290e24 . Are there any problems with the connection?

0
Comment actions Permalink

Hello,


Thank you for your answer but I don't understand it.
In the firsts versions, I could use ODBC as a datasource.
Now I can't anymore, I don't see ODBC as a Drivers.

I have to work on a remote Sybase database and that's the way I was doing it with the first versions of 0xDBE.
On my computer I have an ODBC connexion (a system one) defined and I was using it.


Bye

0
Comment actions Permalink

Sorry for delayed reply,


Now I can't anymore, I don't see ODBC as a Drivers.

Now you can select to create new Datasource via File | Data Sources, click + then select Database Driver option, add driver jar there, choose driver class and create the Datasource. Does this work?

0
Comment actions Permalink

Hello Andrey,


That's ok, I can add a driver, I have used if from rt.jar from those paths (several tries) :

C:\Program Files\SQL Anywhere 12\Sun\jre160_x64\lib
C:\Program Files\Java\jre1.8.0_60\lib
C:\Program Files (x86)\JetBrains\0xDBE 142.4082.2\jre\jre\lib

And now I have a SqlAnywhere datasource where I can sepcify the Host, database, user and password but not the (Sybase) server so my connection is failing.

I have something like this :

jdbc:driver://192.168.0.8/database_name


Bye,
Hervé

0
Comment actions Permalink

And now I have a SqlAnywhere datasource where I can sepcify the Host, database, user and password but not the (Sybase)

What are the dificulties specifying connection string? Note that you may manually edit it.

You can also use Sybase Native Datasource type for configuring Sybase datasource with the driver you want.

0
Comment actions Permalink

Hello,


Sorry I don't succeed to create any connection to  my database, with previous versions I succeed to do it but not with this one, even with native drivers.
I will be using Sql Anywhere... :-(

Thank you for your help, patiente and time.

Bye,
Hervé

0

Please sign in to leave a comment.