session table name bug

Article View: borland.public.cppbuilder.database.ado

Article #3957

Back to borland.public.cppbuilder.database.ado Previous Next

#3957

From: Jerry Irons
Date: Thu, 25 Apr 2002 13:50

21 lines
1672 bytes

For those who are interested:

Create a table in an MS access 2000 database called "Session".

Next, drop an ado component from c++builder, I'll use adodataset.

Build your connection string, using MS Jet provider,  test connection
is ok.  For the command text, use "select * from session".

Try and set your adodataset to active, you'll get "unspecified error".

Rename table in access to anything other than Session, reset your
connection and command text, and you should be able to open it
successfully.

Rename table back to Session, set the provider type to MS OBDC,
instead of Jet, and it works fine.

Must be a bug with a Session variable somewhere in MS Jet provider.

-Jerry

Technical Details

Message-ID: <9m1gcu84bof317rqan448vrc9612j66nod@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!209.251.2.12.MISMATCH!news-xfer2.newshosting.com!newsfeed.icl.net!diablo.netcom.net.uk!netcom.net.uk!news.tele.dk!small.news.tele.dk!193.174.75.178!news-fra1.dfn.de!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,47aa700b47ea78e3,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-04-25 07:09:00 PST
From: Jerry Irons <JIrons@compuserve.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: session table name bug
Date: Thu, 25 Apr 2002 09:50:17 -0400
Message-ID: <9m1gcu84bof317rqan448vrc9612j66nod@4ax.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 24.54.10.7
X-Trace: dnews 1019742668 24.54.10.7 (25 Apr 2002 06:51:08 -0700)
Lines: 21
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!209.251.2.12.MISMATCH!news-xfer2.newshosting.com!newsfeed.icl.net!diablo.netcom.net.uk!netcom.net.uk!news.tele.dk!small.news.tele.dk!193.174.75.178!news-fra1.dfn.de!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!dnews