[DB-SIG] mxODBC question

[Matthew T. Kromer]

Karsten Weinert wrote:

>Hi,
>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?
>Regards,
>Karsten
>