[adodbapi] cannot create table
Bob Gailer
bgailer at alum.rpi.edu
Mon Oct 6 12:36:45 EDT 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