Matevž Mrak
2014-07-11 06:31:07 UTC
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:
Loading Image...
*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
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:
Loading Image...
*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