Re: Trouble w/ 'create table' sql on mx.ODBC

2007-04-05 Thread Greg Corradini
Thanks for responding everyone, I never received a traceback, the program did complete without changes to the database. However, the conn.commit() did work (Thanks Steve). I should've know that was the problem (or at least tried), b/c I saw so many posts about a similar problem with Update and I

Re: Trouble w/ 'create table' sql on mx.ODBC

2007-04-05 Thread Gabriel Genellina
En Thu, 05 Apr 2007 16:25:08 -0300, Greg Corradini <[EMAIL PROTECTED]> escribió: > Lately I've been using the mx.ODBC module to query Access (mdb) tables. > For > the life of me, I can't get the 'create table' sql command to work. I use > this command in Oracle and I've seen other mx.ODBC user

Re: Trouble w/ 'create table' sql on mx.ODBC

2007-04-05 Thread Steve Holden
Greg Corradini wrote: > Hello, > Lately I've been using the mx.ODBC module to query Access (mdb) tables. For > the life of me, I can't get the 'create table' sql command to work. I use > this command in Oracle and I've seen other mx.ODBC users weave into their > scripts for Access. But I still can'

Trouble w/ 'create table' sql on mx.ODBC

2007-04-05 Thread Greg Corradini
Hello, Lately I've been using the mx.ODBC module to query Access (mdb) tables. For the life of me, I can't get the 'create table' sql command to work. I use this command in Oracle and I've seen other mx.ODBC users weave into their scripts for Access. But I still can't get this simple test run belo