Problem with Delphi 7 and ADO RB 7.02

rbuser

Hi,
We are trying to do some testing with the ADO (SQL Server 7) and we keep
getting a default ADO connection dialog box.
It happens when we preview a report and when we edit a join in the query
bulder.

We have applied the D7 MS SQL update and it still happens

It happesn with the end user demo as well.

Thanks,
--
Tony Caduto
AM Software Design
Inexpensive Corporate Instant Messaging
http://www.amsoftwaredesign.com



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.470 / Virus Database: 268 - Release Date: 4/9/2003

digitalmetaphors

Make sure that the database settings on the designer component are correctly
assigned. Set TppDesigner.AllowDataSettingsChange = true and then at
runtime, check the data settings dialog options from the File menu in the
Data tab of the designer. This way you can make sure it is pointing to the
right conneciton object. It sounds as if Dade can't find one so it tries to
create one. The dataview streams down the ADO connection name so that it can
restablish its connection correctly. Try starting from an empty report and
create a new datavivew in the project just to make sure other dataviews,
which may have been created to connect in your testing to other
ADOConncetions, are not involved.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

The first two option you mentioned did not work(settting change,data setting
options dialog)

Then we created a new report and data view and the default logon dialog went
away but the data being returned is not the same as what is being reported
from the same SQL executed in the SQL enterprise manager.

--
Tony Caduto
AM Software Design
Inexpensive Corporate Instant Messaging
http://www.amsoftwaredesign.com

digitalmetaphors

Hit ctrl-left-mouse-click over a dataview to view the 'Magic SQL' that is
submitted to the the server. This is the SQL generated behind the scenes in
order to support master detail linking of dataviews. If you just view the
SQL tab of the query designer of a dataview, it is the SQL specific for that
dataview as if it weren't linked. Perhaps what you are seeing is the
difference between these two SQL statements.


Cheers,

Jim Bennett
Digital Metaphors