Can't Create Data View

rbuser

I am very new to ReportBuilder so please be gentle!

I am trying to use a data dictionary with an end user reporting application.
The application is Delphi 7 based, with Advantage 7.0 and ReportBuilder 7.03

After launching the Explorer from the program and then the Designer, I get
an error when trying to create a data view (File|New|Query Wizard):

"A connection string must be specified prior to connecting......."

The properties for database name in the dictionary, explorer, and designer
all point to TAdsConnection which has a proper connect path (and works for
other database activities.) "Use Data Dictionary" = true in designer. The
dictionary contains the proper tables and fields.

Obviously, I have missed a property somewhere but can't find it.

Any help would be appreciated.

Regards,
Tom

nardmoseley

1. As a first step, try to run the RBuilder\Demos\EndUser
Databases\Advantage demo app. (do not use the DataDictionary). Follow the
directions in the demo's ReadMe.doc.

2. As a second stet try to get your end-user app working without using a
DataDictionary.

3. Now, try to add the DataDictionary back into the equation.

Make sure that all of the End-User supporting tables: Items, Folders,
Tables, Fields, etc are connection to your TADSConnection. Also check the
Designer.DataSettings.

Make sure that your application includes a reference to "daADS" in the uses
clause. Set Designer.AllowDataSettings to true. Then run the application and
from the Data workspace select the File | DataSettings menu option and make
sure the settings are correct.



--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com

rbuser

> 1. As a first step, try to run the RBuilder\Demos\EndUser
I followed the directions in the Readme.doc for installation of all the
required items. Rather than use the project above, I found the End User
Tutorial (..\RBuilder\Tutorials\Complete\II. Applications\02. End-User
Reporting) to be a little easier with which to work.

In the directory (..\UtilMgt\Data) with my primary database (UtilMgtDB.add),
I added the Folder and Item tables (free-standing).

To the original application, I changed the DataSources dsFolder and dsItem
to point to Advantage tables (TAdsTable) that are connected via
TAdsConnection1, which has a connection path of "..\UtilMgt\Data". There
doesn't seem to be any problem with this since I can create folders, etc.

I then added TAdsConnection2 (UtilMgtDB) which has a connection path to
"..\UtilMgt\Data\UtilMgtDB.add". I then set the DataSettings in ppDesigner1
to the following:

DatabaseName: UtilMgtDB
DatabaseType: dtAdvantage
SessionType : ADSDession

In the Launch event, I set the IsConnected properties for both
AdsConnections to true. Launch brings up the Explorer and I can see the
folder I added previously. When I click "New Report", the Report Builder
appears. I click the Data tab and then File|Data Settings, and see the
following:

Session Type: ADSSession
Database Name: UtilMgtDB
Database Type: Advantage
Collation Types: ASCII (Case Sensitive checked)
SQL Type: SQL2 (Allow Edit DQL checked)
Data Dictionary: blank

If I do a File|New|Query Wizard, I get an error "A connection string must be
specified prior to connection."

If I change the connection path in TAdsConnection2 (UtilMgtDB) to
"..\UtilMgt\Data\", eliminating the database name and do File|New|Query
Wizard, I get the Query Wizard dialog, but without any tables listed.

So it would appear that the connection path in TAdsConnection2 (UtilMgtDB)
is the root of my problem. I just don't know what it should be since neither
including or excluding the database name (UtilMgtDB.add) seems to work. What
am I missing?

Regards,
Tom



uses
and
make

nardmoseley

Try setting up and ADS Alias in an ADS.ini file and configuring the
ADSConnection to the use the Alias.


--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com

rbuser