[adodbapi] cannot create table

Bob Gailer bgailer at alum.rpi.edu
Mon Oct 6 18:36:45 CEST 2003


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
bgailer at alum.rpi.edu
303 442 2625
-------------- next part --------------

---
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


More information about the Python-list mailing list