🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

I keep getting this error when I try to select a Table Name from a valid ADO Connection

#2212
From: Allen Shea
Date: Thu, 16 Oct 2003 06:45
91 lines
3879 bytes
I keep running into glitch problems with the ADO features of  Builder 6.

I am currently using Builder 6 with Update 4.

This is a Win2K System with SP4 using MDAC 2.8 and below I have provided the
Summary info for MS Access I have installed.

System Information report written at: 10/15/2003 11:13:22 PM

[Summary]

Item     Value

Application name          Microsoft Access

Version            9.0

Build    2719

Product ID       50083-012-1985595-02540

Application path           C:\Program Files\Microsoft Office\Office\

Language          English (U.S.)

ADO version    2.80

VBA version    6.00

References       VBA, Access, stdole, ADODB

Database name IntrMod.mdb

Database path  C:\Data\Midian\INTERMOD\BorlBuild6

Database size   232.0 KB

Database create date    10/14/2003 8:01:32 PM

Current user     Admin

Jet version        4.0

The ADO Connection String I am using is:

Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=C:\Data\Midian\INTERMOD\BorlBuild6\IntrMod.mdb;Mode=Share Deny
None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry
Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet
OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet
OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet
OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet
OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica
Repair=False;Jet OLEDB:SFP=False


I keep getting this error when I try to select a Table Name from a valid ADO
Connection.  Keep in mind that I was able to select Table Names for 4 tables
and I was going for a 5th table when this happened.  Now none of the tables
will let me select a table name.


Access violation at address 1B0D1041 in module msjet40.dll. Read of address
00000008.


Selecting a Table Name used to work perfectly and just quit working.  I do
not get any compile errors and the application runs and connects like it is
suppose to.  I am able to make changes to the database and alter the tables
and perform queries etc. etc.  But these errors are really annoying.


If I tell the compiler to save after one of these errors when I exit I get
this error after getting
the above error:


bcb.exe - Application Error

The instruction at 0x400375f3 referenced at 0x03411408.  The memory could
not be read.

Click OK to terminate the program.


I went ahead and uninstalled Builder 6 Professional and reinstalled it.  The
uninstalling and the reinstalling fixed the problem at first but now it is
back.  This is the only development application I am having problems with.

Is there something I am missing or what.  Thanks for your feedback in
advance.
Technical Details
Message-ID: <3f8e3ecb$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-04!sn-xit-06!sn-xit-05!sn-xit-08!supernews.com!newsfeeds.sol.net!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,362494acffb83c17,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-10-16 00:12:51 PST
Reply-To: "Allen Shea" <allen@midians.com>
From: "Allen Shea" <allen@midians.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: I keep getting this error when I try to select a Table Name from a valid ADO Connection
Date: Wed, 15 Oct 2003 23:45:54 -0700
Lines: 97
Organization: Midian Electronics
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 68.38.48.136
Message-ID: <3f8e3ecb$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1066286795 68.38.48.136 (15 Oct 2003 23:46:35 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-04!sn-xit-06!sn-xit-05!sn-xit-08!supernews.com!newsfeeds.sol.net!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail