[DB-SIG] mxODBC question

Matthew T. Kromer matt@zope.com
Wed, 28 Aug 2002 10:24:29 -0400

Karsten Weinert wrote:

>the following behavior of the Access ODBC driver 
>and/or *Python with mxODBC is a problem for me:* I open a ODBC connection, do some
>SQL-statements, for example create a new table an put some data in it.
>Then I close the connection. When I open the connection again, the new
>table has disappeared!
>  # put some data in the table
>  for i in range(10):
>    sqlmsg="INSERT INTO test13 VALUES (%d,%d)" % (i, i*i)
>    print(sqlmsg)
>    curs.execute(sqlmsg)

You need a conn.commit() right here to commit your changes.  Otherwise, 
they're being rolled back for you automatically.

>Can you please give me some advice what I did wrong?