[unixODBC-support] [unixODBC][Driver Manager]Function sequence error

Matevž Mrak matevz.mr at gmail.com
Fri Jul 11 09:33:13 BST 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://shrani.si/f/30/P8/3E6CUA0m/screen-shot-2014-07-10-a.png

this is ODBC trace LOG: http://pastie.org/9377035

All user defined types used in create script " Statement = 0x10113a200

			SQL = [Create Table Currencies (
  crn_id ana_id not null PRIMARY KEY NONCLUSTERED,
  crn_cdate ana_datetime not null,

  crn_cuser nvar...][length = 510]" are stored in database before and
executed normally:

http://shrani.si/f/h/5F/3Qwju421/screen-shot-2014-07-11-a.png

*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.248Database   = 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 (sample create 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)

Best regards, Matevz

-- 
Lep pozdrav,
Matevž Mrak
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20140711/61785d9d/attachment-0001.html>


More information about the unixODBC-support mailing list