Connect to Sybase SQL Anywhere DB

Avatar
Permanently deleted user
Created

Hello, i'm totally new.
I have a Sybase SQL Anywhere 11 Database and a ODBC to a local Database file for the connection.
I want have a quick look on Datagrip with the 30 days free license, before i try to master the new things.

Can someone help me with the connection to the Sybase SQL Anywhere Database?
Is it possible to connect with a ODBC to a local Database file?

Thanks
greetings
Jenson

Votes

0

Share

3 comments
Avatar
vasily chernov
Created

Hi,

DataGrip works only with jdbc connections.

Thank you.

 

0
Avatar
Kristjan Kiolein
Created

This is how I was able to connect to SQL Anywhere database from JetBrains IDE.
 

First I created a new driver with two files from SQL Anywhere installation folder:

 

Then connected to database using that driver.

I had data source defined in “ODBC Data Source Administrator” so I could use this connection string jdbc:sqlanywhere:DSN=<ODBC-name>


Alternatively it is possible to connect with this connection string: jdbc:sqlanywhere:Host=<ip>:<port>;ServerName=<server>;DatabaseName=<db>; with authentication method “User & Password” selected in the Data Sources config window.

Or the user can be specified in connection string jdbc:sqlanywhere:Host=<ip>:<port>;UserID=<user>;Password=<pw>;ServerName=<server>;DatabaseName=<db>;

 

 

0
Avatar
Aleksandr Molchanov
Created
Please use this link to upvote for SQL Anywhere support in DataGrip

https://youtrack.jetbrains.com/issue/DBE-16801/SQL-Anywhere-support-in-DataGrip
0

Please sign in to leave a comment.