[adodbapi] cannot create table
Sangbae
strider at chol.com
Mon Oct 6 00:48:56 EDT 2003
I cannot create table using adodbapi.
I have no problem with SELECT etc.
But I can create table using win32com.client directly.
I don't know why.
Could you give some advice, please?
This is my source.
=====================================
from adodbapi import adodbapi
DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=test.mdb;'
stdconn = adodbapi.connect(DSN)
cur = stdconn.cursor()
query = """
CREATE TABLE table01 (
id COUNTER(1, 1) PRIMARY KEY,
name VARCHAR(255) NOT NULL DEFAULT "",
comment VARCHAR(255) NOT NULL DEFAULT ""
)"""
# api
cur.execute(query)
cur.close()
stdconn.close()
======================================
More information about the Python-list
mailing list