[python-win32] ADOX catalog.Table.Append error -- 'The parameter is incorrect.',

[eric.powell at srs.gov]

Might I suggest just using a "CREATE TABLE" sql statement through ADO 
instead?

       sqlstatement = "CREATE TABLE SPAM (SpamID Int Not Null, Eggs 
Char(20));"
       conn = win32com.client.Dispatch(r'ADODB.Connection')
       DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=' + self.dbpath 
+ ';'
       conn.Open(DSN)
       #Query the recordset - should be in module with establishing 
connection stuff
       rs = win32com.client.Dispatch(r'ADODB.Recordset')
       try:
            rs.Open(sqlstatement, conn,1 ,3)
        except:
            print 'DB Error'


Eric B. Powell
BSRI
Electronic Aids
(803)208-6207




Jim.Vickroy at noaa.gov 
Sent by: python-win32-bounces at python.org
07/10/2006 05:52 PM

To
python-win32 at python.org
cc

Subject
[python-win32] ADOX catalog.Table.Append error -- 'The parameter is 
incorrect.',






Hello,

I am a novice user of ADOX who is attempting to create a database and 
a table in it.

I seem to be able to create a SQL Express database but am unable to 
add a table to it.

The attached script (adox.py) illustrates the difficulty.

Any suggestions would be appreciated.

Thanks,

-- jv
_______________________________________________
Python-win32 mailing list
Python-win32 at python.org
http://mail.python.org/mailman/listinfo/python-win32

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/python-win32/attachments/20060711/78d417db/attachment.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: adox.py
Type: application/octet-stream
Size: 1277 bytes
Desc: not available
Url : http://mail.python.org/pipermail/python-win32/attachments/20060711/78d417db/attachment.obj