[unixODBC][Driver Manager]Function sequence error

Thursday, July 10, 2014

I am using mxODBC with unixODBC and FreeTD driver 8.0 on OSX to connect MSSQL Server 2008 R2 on other Windows machine in network.


I can connect with python and execute queries but when creating database with script I am getting this error:



InterfaceError: ('HY010', 0, '[unixODBC][Driver Manager]Function sequence error', 5258)
- File "/Users/matevzmrak/Desktop/praksa_fajli/projekt/ana/ana/srv/orm/driver.py", line 101, in execute
[0m[31m15:28:59.787 0.0.0.0 {unknown} - Query to execute: sp_pkeys 'Currencies' - File "/Users/matevzmrak/Desktop/praksa_fajli/projekt/ana/ana/srv/orm/driver.py", line 102, in execute


at this qry:


http://ift.tt/1k9nnPq


freetds.conf:



[DSNmy]
host = 10.13.7.248
port = 1433
tds version = 8.0
client charset = UTF-8


odbc.ini:



[ODBC Data Sources]
DSNmy = mysqlDriver

[DSNmy]
Driver = /usr/local/Cellar/freetds/lib/libtdsodbc.so
Server = 10.13.7.248
Database = tst
UID = ana-rpc
PWD = s21s22
Port = 1433
TDS_Version = 8.0


odbcinst.ini:



[ODBC Drivers]
mysqlDriver = Installed

[mysqlDriver]
Driver = /usr/local/Cellar/freetds/lib/libtdsodbc.so
Setup = /usr/local/Cellar/freetds/lib/libtdsodbc.so
UsageCount = 1


Specs:


MSSQL Server: 2008 R2

FreeTDS: latest stable version

OSX version: 10.9.3

UCS: UCS2

Eclipse: Eclipse Standard/SDK - Kepler Service Release - Build id: 20140224-0627

Python: 2.7.6 - 64bit

mxBase version: egenix-mx-base-3.2.7-py2.7_ucs2-macosx-10.5-x86_64-prebuilt

mxODBC version: egenix-mxodbc-3.1.2.macosx-10.5-x86_64-py2.7_ucs2.prebuilt

unixODBC: 2.3.2 (this sample script works normally with no error, on my case there is probably some issue with driver because database create is working without problems on Windows machine)



from mx.ODBC.unixODBC import DriverConnect

db = DriverConnect('DSN=DSNmy;UID=ana-rpc;PWD=s21s22')
print db
c = db.cursor()

c.execute('''CREATE TABLE article (
article_name varchar(20),
article_desc varchar(20));''')

db.commit()


Best regards, Matevz







http://ift.tt/1rXK5BV