0

I am Working on Ubuntu 18.04 when I am using Pyodbc connection with SQL Anywhere 17 Driver to connect to a Sybase DB, while trying to establish connection my Jupyter notebook Dies. The expectation is, I should be able to run this code in Ubunt and connect to a Sybase DB.

I can connect and run query from Windows without problems(using DSN).

I have been working with other driver and SQL Server, MySQL and MariaDB and I have not encountered any problems. I believe connection to Sybase database needs SQLANYWHERE DRVIER.

If Someone knows how get the connection string which is passed from pyodbc to the server when I use a DSN?(maybe this could give me an idea to know what i'm doing wrong).

Some advice?

Code run in windows without problems

import pyodbc
import pandas as pd

cnxn = pyodbc.connect("DSN=RevDSN")
print(cnxn)
data = pd.DataFrame(pd.read_sql_query(query, cnxn))
cnxn.close()
Shibu Tewar
  • 136
  • 1
  • 5
Alan Zavala
  • 21
  • 5
  • Is the "Sybase DB" to which you are trying to connect a "SAP SQL Anywhere" database or a "SAP ASE" database? "SQL Anywhere" and "ASE" are [not the same thing](https://en.wikipedia.org/wiki/SQL_Anywhere#Differences_between_SAP_ASE_and_SAP_Sybase_SQL_Anywhere). – Gord Thompson May 27 '20 at 22:49

1 Answers1

0

Since I didn't find a good explanation I am putting this here.

I installed the client from

https://archive.sap.com/documents/docs/DOC-35857

then followed the basic instructions from

https://wiki.scn.sap.com/wiki/display/SQLANY/Installing+SQL+Anywhere+17+on+Ubuntu+14.04

The ODBC Client will not ask for the keys

As the documentation says the important part is running the sa_config.sh and making sure that the exports happen.

Lastly edit the /etc/odbcinst.ini file and add the driver.

For example

[SQL Anywhere 17]
Driver=/opt/sqlanywhere17/lib64/libdbodbc17.so
TDS_Version=5.0
UsageCount=1

Then I used this connection string

import pyodbc
cnxn = pyodbc.connect('Driver={SQL Anywhere 17};LINKS=TCPIP{HOST=<server ip here>};PORT=2638;UID=admin;PWD=<password here>;ENG=<engine name>;DBN=<database name>;')
cursor = cnxn.cursor()
cursor.execute("select top 10 * from dba.<table name>") 
for row in cursor:                                                                   
     print(row)

And it worked.

Stephen Hamel-Smith
  • 1
  • 1