Skip to Content.
Sympa Menu

freetds - Re: [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: Re: [freetds] [unixODBC][Driver Manager]Function sequence error
  • Date: Fri, 11 Jul 2014 09:29:12 +0200

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




Archive powered by MHonArc 2.6.24.

Top of Page