DB test doesn't work in Komodo

2001-08-29 Thread Andrew Malcolmson
When I run the simple (Access XP via ODBC) database test script below, interactively and in PythonWin it works but in Komodo 1.1 it doesn't. A '1' result is returned but the row isn't inserted. import dbi, odbc sqlInsert = "INSERT INTO table_name(field_name) VALUES ('blah')" myconn = odbc.odbc('

RE: DB test doesn't work in Komodo

2001-08-30 Thread Andrew Malcolmson
Hi, To answer your questions, yes, the script works at the command line. The only Python on my machine is ActivePython 2.1.1. I have got it the script working in Komodo though. For some reason, if I execute a SELECT following the INSERT using the same cursor, the database is updated. If you hav

Re: ISP whose server admit Python

2001-09-24 Thread Andrew Malcolmson
My Web hosting provider Vex.net (www.vex.net) in Toronto, Canada is the host and creator of the Vaults of Parnassus Python script repository and runs Python 2.0 on NetBSD. They specialize in selling shell access. This would be a great place to try out some Python cgi scripts or whatever you ha