Hi,

I am using Raspberry PI 3 Model B and have installed SQL Anywhere 17 on it. I am following SCN blogs which showed how to install SQL Anywhere and also connect to it via a Python program.

http://scn.sap.com/community/sql-anywhere/blog/2014/08/11/sql-anywhere-available-for-linux-on-arm

When I execute my python program, I get an error "Could not load dbcapi".

After installing SQL Anywhere, I used the below commands to set the PATH and create a new DB.

source "/home/pi/MySql/bin32/sa_config.sh"
dbsrv17 –v (returns 17.0.0.1063)
dbinit mysqlaDB.db -dba murali,sql123
dbsrv17 -ud mysqlaDB.db

I installed PIP and sqlanydb libraries using below commands

sudo apt-get install python-pip  
sudo pip install sqlanydb

I copied the sample code to test the python script. I already have pythoin 2.7.9 installed on my Raspberry PI.

import sqlanydb  
conn = sqlanydb.connect(uid=’murali’, pwd='sql123', eng='mysqlaDB', dbn='mysqlaDB' )  
curs = conn.cursor()  
curs.execute("select 'Hello, world!'")  
print "SQL Anywhere says: %s" % curs.fetchone()  
curs.close()  
conn.close()

Below are some information on my Path settings and System OS info.

pi@raspberrypi:~/Sample Code $ env | grep PATH
LD_LIBRARY_PATH=/home/pi/MySql/lib32:
XDG_SESSION_PATH=/org/freedesktop/DisplayManager/Session0
XDG_SEAT_PATH=/org/freedesktop/DisplayManager/Seat0    PATH=/home/pi/MySql/bin32:/home/pi/MySql/bin64:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/local/games:/usr/games

NODE_PATH=/home/pi/MySql/node:

pi@raspberrypi:~/Sample Code $ cat /etc/os-release
PRETTY_NAME="Raspbian GNU/Linux 8 (jessie)"
NAME="Raspbian GNU/Linux"
VERSION_ID="8"
VERSION="8 (jessie)"
ID=raspbian
ID_LIKE=debian
HOME_URL="http://www.raspbian.org/"
SUPPORT_URL="http://www.raspbian.org/RaspbianForums"
BUG_REPORT_URL=http://www.raspbian.org/RaspbianBugs

However, I was able to use the terminal to connect to the newly created DB using the following commands.

dbspawn -f dbsrv17 -n mysqlaDB -o server.out mysqlaDB.db
dbisqlc

I started the demo DB and tried to use python script to connect to it. It gave me the same error message.

Below is the complete error message.

pi@raspberrypi:~/Sample Code $ sudo python MySQL01.py
Traceback (most recent call last):
  File "MySQL01.py", line 2, in <module>
    conn = sqlanydb.connect(uid='dba', pwd='sql', eng='demo', dbn='demo' )
  File "/usr/local/lib/python2.7/dist-packages/sqlanydb.py", line 522, in connect
    return Connection(args, kwargs)
  File "/usr/local/lib/python2.7/dist-packages/sqlanydb.py", line 538, in __init__
    parent = Connection.cls_parent = Root("PYTHON")
  File "/usr/local/lib/python2.7/dist-packages/sqlanydb.py", line 464, in __init__
    'libdbcapi_r.dylib')
  File "/usr/local/lib/python2.7/dist-packages/sqlanydb.py", line 456, in load_library
    raise InterfaceError("Could not load dbcapi.  Tried: " + ','.join(names))
TypeError: sequence item 0: expected string, NoneType found

Thanks, Murali