[adodbapi] cannot create table

[Sangbae]

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()
======================================

[Bob Gailer]

At 10:48 PM 10/5/2003, Sangbae wrote:

I cannot create table using adodbapi.
<gripe on>
I have the same problem especially with Microsoft messages: "Cannot do blah
blah". No hint as to what the problem is.
<gripe off>

PLEASE tell us what the symptom is. Error message, no error message but
also no new table, or what?
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()
======================================
--
http://mail.python.org/mailman/listinfo/python-list
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.521 / Virus Database: 319 - Release Date: 9/23/2003

Bob Gailer
bg*****@alum.rpi.edu
303 442 2625
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.521 / Virus Database: 319 - Release Date: 9/23/2003