Have you guys ever deal with this error? dbi.no-error?
On 10/19/07, Carl Karsten <[EMAIL PROTECTED]> wrote: > Lukasz Szybalski wrote: > > Hello, > > I have a python program that converts some data and writes it via ODBC > > driver. > > I am using a win32 dbi,odbc to do that. (none of the free other ones work) > > Did you try http://ceodbc.sourceforge.net ? > > I missed it the first time I went searching for odbc modules. > > When I tried it, I got an error that according to the driver docs was only > applicable to the jdbc driver, which I wasn't using. > > Turns out the odbc driver had a bug in it, and Anthony (ceODBC author) > responded > with a workaround (rename my exe to msdev.exe!) within a day, and within a > week > had a ceODBC update that had a more elegant workaround. (he can't fix bugs in > someone elses odbc driver, so workaround is as good as it will get) > Quick test to see if it can do a simple thing. >>> c=ceODBC.Connection('DSN=PMS',) >>> d=c.cursor() >>> d.execute('select * from PMSr') Traceback (most recent call last): File "<stdin>", line 1, in <module> ceODBC.NotSupportedError: Variable_TypeBySqlDataType: unhandled data type 92 >>> I guess datetime field or ulong is not supported. So I guess I will stick to what I have. Thanks for the info do. _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
