Sybase and ODBC

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?

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

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?

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é

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.

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é