FreeTDS Development Group

[Matevž Mrak <matevz.mr AT gmail.com>]

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