FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

Cannot see any error in the trace

Frediano


2014-07-11 8:29 GMT+01:00 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>