Re: odbc script

2004-12-24 Thread Benji York
Michele Petrazzo wrote: Of course, if you want to help me to make it db-api 2 compatible, you are welcome! Unfortunately I don't have much time to volunteer, but when you embark on the road to DB API 2.0 compliance I have a fairly extensive test suite you can have. -- Benji York -- http://mail.py

Re: odbc script

2004-12-24 Thread Michele Petrazzo
Steve Holden wrote: you might want to look at www.egenix.com and think about installing the mxODBC module, which I have used with very good results. regards Steve If you want, I have created realpyodbc, that is a class for create an interface between python and odbc with ctypes's help . For now

Re: odbc script

2004-12-23 Thread Benji York
Steve Holden wrote: you might want to look at www.egenix.com and think about installing the mxODBC module, which I have used with very good results. I'd also recommend checking out the imaginatively named adodbapi (http://adodbapi.sourceforge.net/) which allows you to use any ODBC driver through

Re: odbc script

2004-12-21 Thread Peter Hansen
Steve Holden wrote: Please note that the odbc module is a bit long in the totth now, though it surely is convenient to get it with win32all. If this work is being done for personal use you might want to look at www.egenix.com and think about installing the mxODBC module, which I have used with v

Re: odbc script

2004-12-21 Thread Steve Holden
Chris wrote: Thanks Benji, I took your advice and added in the conn.commit() into the script but still had the same problem. I did some digging around the odbc documentation and found this bug:

Re: odbc script

2004-12-20 Thread Chris
Thanks Benji, I took your advice and added in the conn.commit() into the script but still had the same problem. I did some digging around the odbc documentation and found this bug: *

Re: odbc script

2004-12-19 Thread Benji York
Chris wrote: what ever is the last loop through doesn't seem to update the database? Try a conn.commit() after your loop. -- Benji York -- http://mail.python.org/mailman/listinfo/python-list

odbc script

2004-12-18 Thread Chris
Hello, I posted a while back about a newbie database question and got a lot of great help here. My script that I am creating has come a long way (For me!) and almost does what I need it too. I am basicly using a dictionary to update a access database using an odbc connector. I am ab