🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: problem to access database of Access 97

#5776
From: Jerry Bloomfield (TeamB)
Date: Sun, 11 Feb 2001 01:25
35 lines
2883 bytes
On Fri, 26 Jan 2001 10:04:41 +0100, Xin Chen <chenxin@ibf.rwth-aachen.de>
wrote:

>thank you Jirzi, but I do think it is a ACCESS related problem, because
>I have resolved this problem by using Foxpro-database without any change
>of my program, in addition, there is even no support for ACCESS2000.
>BTW, I have tried to set many breakpoints in the programs, but the error
>came before all breakpoints.

Just because it is working for a different database does not mean that the
problem isn't in your code and/or configuration.  I use C++Builder to work
with MS-Access97 MDB files fairly regularly and do not have the problems
you were describing.  

Also,  you mention Access97 in the subject but Access2000 in the body,
which one are you trying to use?  If you are trying to use Access2000 with
anything other than ODBC or ADO,  you are attempting to use something which
is unsupported.  Thanks to MS,  the only way to connect to Acces2000 MDB
files when C++Builder v5 was released were ODBC and ADO,  and there were
known problems with ODBC at that time...

The error may well be caused by a bad BDE configuration for your Alias
and/or driver.  This could explain the problem occurring before your
winmain() function,  as it would then be happening during the BDE
initialization.  I just wrote a couple of quick test applications this
afternoon using (one using ODBC and the other using ADO) to connect to an
Access2000 MDB file,  and they both worked perfectly,  with no errors or
exceptions,  so I strongly suspect that "Jirzi" is giving you a good lead
to work with...

Jerry Bloomfield (TeamB)
-- 
http://www.teamb.com                                      JersWork@wwa.com
Please do *NOT* send private e-mail without prior permission (my anti-spam 
filters will probably just delete it anyway <g>)
Technical Details
Message-ID: <s2qb8tslekjbnlbsndcvi5jbmk0qtom7pd@4ax.com>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!xfer13.netnews.com!netnews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!not-for-mail
References: <3A5F1AF1.2E326A25@ibf.rwth-aachen.de> <93nmvp$c5h1@bornews.inprise.com> <3A713DA9.B7A28456@ibf.rwth-aachen.de>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,8b4581990e3e691a
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-02-10 17:31:36 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!xfer13.netnews.com!netnews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!not-for-mail
From: "Jerry Bloomfield (TeamB)" <JersWork@wwa.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: problem to access database of Access 97
Date: Sat, 10 Feb 2001 19:25:12 -0600
Organization: LSVFA - Latest Software Version Freaks Anonomous
Lines: 35
Message-ID: <s2qb8tslekjbnlbsndcvi5jbmk0qtom7pd@4ax.com>
References: <3A5F1AF1.2E326A25@ibf.rwth-aachen.de> <93nmvp$c5h1@bornews.inprise.com> <3A713DA9.B7A28456@ibf.rwth-aachen.de>
NNTP-Posting-Host: 157-238-73-216.il.verio.net
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Newsreader: Forte Agent 1.8/32.548