Access Violation

rbuser

I get an AV when trying to Create Queries in the Data Tab of the report
designer. Neither Query Wizard nor Query Designer works. The AV's looks like
this:

Access Violation at adress 060A3A59 in module 'rbADO77.bpl'. Read of address
00000000

I have tried uninstalling and reinstalling from the control panel, because
it does not seem to work from the install packages in D7. Unless there is a
certain order to do things.

Please give me some guidance here.

Thanks,

Jonas

nicocizik

Hi Jonas,

Does this AV occur at design time or at run time? If it is happening at run
time, see if you can trace the error in the ReportBuilder source and find
out where it is occuring by setting your debugger to stop on exceptions.

--

rbuser

Hi Nico,

It occurs at design time, which makes it harder to figure out.

Jonas

nicocizik

Hi Jonas,

Please give me the exact steps you take to create this error and I will try
to recreate it on my machine. Also... which operating system are you
running? Which version of ReportBuilder are you running?

--

rbuser

Nico,

I have a small form and on it I have some pipelines and datasources/tables
and report component and a designeer.

After setting the Pipeline, I doubleclick the report component and when in
the report I click the data tab, click file, then new, and then either of
the query options, after that the AV occurs.
I am running XP home and my RB version is 7.03. The only difference between
my system and the ones that wok is that I did have the trial installed befoe
installing the "real" version, could this be causing anything?

Thanks,

Jonas

nicocizik

Hi Jonas,

Are you using MS SQL Server or MS Access? Are you able to recreate the
issue by creating a simple application with only a form, report,
ADOConnection, and a button?

--

rbuser

Mornin' Nico,

I am using DBISAM from Elevate. I am able to recreate the issue every time,
and I created a form that has a data source, table, db pipeline and report
on it, and when I go into the data tab a design time I get the AV when
trying to create a query. I do now think it is related to the database
because this works fine on all our other systems.

Is there a way to delete report builder completely that you recommend?
Should I remove reistry entries? Additional Files?

Jonas

nicocizik

Hi Jonas,

This is interesting... I'm unclear why it's AV'ing in the rbADO file when
you are using DBISAM. Take a look at the following article on cleaning up a
corrupt installation. This will give you a fresh start on your computer to
try again.

--------------------------------------------
Article: Cleaning up a Corrupt Installation
--------------------------------------------

If you have been advised by Digital Metaphors technical support that you may
have a corrupt installation, or if you are having difficulty installing,
compiling or running applications after a ReportBuilder install, then it may
be necessary to manually remove all ReportBuilder files from your system.
Corrupt installations usually result when you are installing over a previous
version of ReportBuilder which was not installed into the default directory,
which was recompiled from the source, or when ReportBuilder files were
manually moved from the default install location. Cleaning up a corrupt
installation, consists of locating all ReportBuilder related files, and
deleting them from your system. The first step is to use the uninstall
program to remove as much of ReportBuilder as possible.


Run the uninstall program

1. Exit Delphi, and all other applications. You should have no applications
running except the uninstall, otherwise you may lose some of your work.

2. Select Start | Settings | Control Panel from your Windows desktop.

3. Double-click the Add/Remove programs icon.

4. Locate the version of ReportBuilder you wish uninstall and double-click
it.

5. The first page of the Uninstall Wizard allows you to choose between an
Automatic or Custom uninstall. Choose Custom and click the Next button.

6. Click the Select All button, then the Next button. Repeat these steps
until you reach the last page of the wizard.

7. Click the Finish button. All of the items you selected will be removed
from the system.

8. After all the ReportBuilder files are removed, you may be prompted to
reboot the system. If this is the case, reboot the system.


Delete the ReportBuilder root directory (and all subdirectories)

1. Using the Windows Explorer, locate the ReportBuilder root directory. The
default directory is:

C:\Program Files\Borland\DelphiX\RBuilder

2. Once you have located this directory, inspect it. If you have any custom
work in this directory which you would like to keep, move it to another
directory.

3. Delete the ReportBuilder root directory.


Delete all remaining ReportBuilder files

1. Using the Windows Explorer, search the entire hard drive for all
occurrences of:

dclRB*.bpl
dclRB*.dcp
rb*.bpl
rb*.dcp

2. Delete any occurrences which correspond to the version you are removing.
All packages are named with the convention NN, where the first number
is the ReportBuilder version and the second number is the Delphi version.
Thus, a typical package name for Delphi 5 would be rbRCL45.bpl. The same
package for Delphi 4 would be: rbRCL44.bpl. Check Installing ReportBuilder
for a list of the packages associated with each version.

3. Using the Windows Explorer, search your hard drive for all occurrences
of:

pp*.*
da*.*
ra*.*

4. These are the prefixes used by individual ReportBuilder units. 'pp' is
used for ReportBuilder units, 'da' is used for DADE units, and 'ra' is used
for RAP units. Depending on which ReportBuilder you have (Standard,
Professional or Enterprise) you may not have all of these unit types.



Additional Notes

1. Never have Delphi running when installing ReportBuilder.

2. All ReportBuilder related files should be stored in the root directory
$(DELPHI)\RBuilder.

3. All ReportBuilder run-time packages should be stored in the
Windows\System directory.

4. You should never have ReportBuilder files in Delphi\Lib, Delphi\Bin or
Delphi\Projects\Bpl.

--

rbuser

Nico,

Very Interesting...
I followed the steps below, but without luck. Would it make any difference
that I had the trial version installed before purchasing?

Jonas

nicocizik

Hi Jonas,

Having the trial version installed before purchasing should not have an
effect on how the main product works, especially if you went through all the
steps of cleaning up a corrupt installation. If this works correctly at
work, there still needs to be some difference on your other computer. Be
sure your library paths are correct and that you are not using any old bpl
files from your Window/System32 directory. Be sure the correct dade package
is being used in your Delphi IDE as well as the correct DBISAM package. You
might want to try un-installing the Dade ADO package from the IDE to see if
that helps.

--