FreeTDS Development Group

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

I forgot to post my ODBC trace log: http://pastie.org/9377035

Best regards, Matevz


2014-07-11 8:31 GMT+02:00 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
>



-- 
Lep pozdrav,
Matevž Mrak