[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