> 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('DSN_Name')
> cursor = myconn.cursor()
> cursor.execute(sqlInsert)
> myconn.commit()
> cursor.close()
> myconn.close()
>
> Any ideas?
Does the script work correctly when you run in from the commandline
i.e. python yourscript.py? Also, do you have more than one version of
Python installed?
Cheers,
Brian
_______________________________________________
ActivePython mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/activepython