A package which provides a python interface to the SQL Anywhere database server.
sqlanydb is a package which provides a python interface to the SQL Anywhere database server. This interface conforms to PEP 249.
Questions tagged [sqlanydb]
11 questions
5
votes
4 answers
sqlanydb windows could not load dbcapi
I am trying to connect to a SQL Anywhere database via python. I have created the DSN and I can use command prompt to connect to the database using dbisql - c "DNS=myDSN". When I try to connect through python using con = sqlanydb.connect(DSN=…
Brian K
- 61
- 1
- 4
2
votes
1 answer
Python and SQL Anywhere 17 trouble with "Could not load dbcapi"
I installed SQL Anywhere 17 client. I ran /opt/sqlanywhere17/bin64/sa_config.sh And still have problem with sqlanydb.InterfaceError: ('Could not load dbcapi. Tried:None,dbcapi.dll,libdbcapi_r.so,libdbcapi_r.dylib', 0)
#!/usr/bin/python3.6
# -*-…
user9733940
2
votes
0 answers
load data on SAP IQ using python + sqlanydb. 'Operation failed on file due to file permissions
I'm trying to make a quick file upload to a table via python on SAP IQ. Faced such a problem. Initially, the user has access to download files using load table (...) using client file ... instruction. If you use the software from SAP (interactive…
tews
- 21
- 3
2
votes
3 answers
Starting a database connection with sqlanydb inside a fork
Based on an example for forking, I build up this little script:
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import sqlanydb
import os
def child():
conn = sqlanydb.connect(uid='dba', pwd='sql', eng='somedb_IQ', dbn='somedb')
curs =…
frlan
- 6,950
- 3
- 31
- 72
1
vote
1 answer
sqlanydb query on damaged SQL Anywhere table disconnects connection, produces OperationalError (Communication Error -85)
I was using python and sqlanydb to query a Sybase Anywhere database file. Most queries were working, but any SELECT query involving a particular table:
conn = sqlanydb.connect(**{"uid":"dba", "pwd":"sql", "dbf":"file.db"})
cursor =…
Richard C Yeh
- 61
- 5
0
votes
1 answer
Django - how to correctly install library without pip in venv to work after deployment
According to this guide I successfully connected to Sybase database in my django project in virtual environment.
After deployment in Apache the web writes this error message
Environment:
Request Method: GET
Request URL:…
xralf
- 3,312
- 45
- 129
- 200
0
votes
0 answers
OperationalError at /admin/sybase_app/packageweight/ (b"Table 'sybase_app_packageweight' not found", -141)
When I edit my admin.py file
from django.contrib import admin
from .models import Packageweight
admin.site.register(Packageweight)
and the run python manage.py runserver and click in the admin page on Packageweight it throws this…
xralf
- 3,312
- 45
- 129
- 200
0
votes
1 answer
How can I get libdbcapi_r.so, libdbcapi_r.dylib needed for sqlany-django?
I installed and configured sqlany-django, but have error Could not load dbcapi: Tried: dbcapi.dll, libdbcapi_r.so, libdbcapi_r.dylib.
I installed sqlany-django with pip install sqlany-django. According to this I should run
$ .…
xralf
- 3,312
- 45
- 129
- 200
0
votes
2 answers
module 'django.db.backends.utils' has no attribute 'typecast_decimal'
When I run
python manage.py inspectdb --database=sybase_database
it ends with error message:
Database.register_converter(Database.DT_DECIMAL, util.typecast_decimal) AttributeError: module 'django.db.backends.utils' has no attribute…
xralf
- 3,312
- 45
- 129
- 200
0
votes
3 answers
Pandas pd.read_sql_query does not return the datetime/timestamp correctly (missing seconds)
Running the following query via pandas:
conn = sqlanydb.connect( userid='xx', password='xx', eng='xx', commlinks='tcpip{host=xx port=xx}' )
query = '''select top 20 log_ts from my_table'''
sql_output = pd.read_sql_query(query, conn,…
mask
- 539
- 1
- 5
- 18
0
votes
0 answers
NodeJS anyDB lost connection
Hello i have made a chat app in nodejs and it works fine on my machine but when i try it on my vps it always stops running when it try's to connect to the database this is the error log i get
root@server:/etc/init.d# node…
HyperGainZ
- 75
- 1
- 10