[unixODBC][Driver Manager]Function sequence error

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[unixODBC][Driver Manager]Function sequence error

Matevž Mrak

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.248
Database   = 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

_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|

Re: [unixODBC][Driver Manager]Function sequence error

Nick Gorham-2
On 11/07/14 09:33, Matevž Mrak wrote:

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


Hi,

I can't tell. That log seems to stop at the point of the create.

--
Nick

_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support