Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Matevž Mrak <matevz.mr AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] [unixODBC][Driver Manager]Function sequence error
  • Date: Fri, 11 Jul 2014 08:31:07 +0200

I am using mxODBC with unixODBC and FreeTDS 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

*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 (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

--
Lep pozdrav,
Matevž Mrak




Archive powered by MHonArc 2.6.24.

Top of Page