 |
GreatManuals.com |
|
|
ODBC Setup You start by selecting menu option [File] [Gateway File Setup...]
Click on data file type: ODBC. Click on [OK].
Here's where you name the Drill-Down Tally gateway file (.ddt). that will hold your sql statements for the report datasets. A suggestive message to help you keep a consistent naming convention with your ODBC filename(s). No need to add the file extension. Drill-Down Tally will automatically add .ddt to the filename you give it. When finished, click [OK].
Enter your filename for the Drill-Down Tally gateway here. We suggest you put the .ddt file in the same directory as the ODBC files if all possible, but not mandatory. We also suggest you give it the same name as the ODBC filename(s) without the .ddt extension that you want to create reports from. In the example above we are going to create reports from a Lotus Notes file named Home Building.nsf. So we first find the directory where the Home Building.nsf is located. Then we enter Home Building for the name of the Drill-Down Tally gateway filename without the extension. When finished, click [Open].
You must enter the connect string setting for Drill-Down Tally to see your ODBC data. First give your gateway file an Application Description name (32 maximum characters). We are using a Lotus Notes file for this ODBC example, so I will give it a description of Lotus Notes Home Building and a sample download directory with the same name in the top part of the screen. NOTE: Drill-Down Tally creates an ODBC DSN with the Application Description you entered above. So make sure you create an unique Application Description that does not conflict with your current ODBC DSN's that are setup. For the DAO Connect String you can select the setting and then press [F3] to open up a zoom box and enter the ODBC DSN-less connect string like the picture below. You could also type in ODBC;DSN=YourDSN if you already have a DSN setup to your data.
NOTE: You can find additional help about your database ODBC connect string by going to Google on the internet. Then typing in search keywords: YourDatabaseFormatHere ODBC connect string. The search results should give you plenty of websites to find examples and solutions to your specific ODBC driver. Or you can click on [...] box at the end of the setting to open up a wizard to help create your ODBC connect string.
If you can click on [...] box at the end of the setting you will open the wizard below to help create your ODBC connect string.
You can select the DSN option at the top of the screen and choose from the available DSN's already setup through the ODBC Administration tool under your OS control panel. Click [OK] when you are done with your settings. Or you can enter the connect string in the lower part of this wizard. Again there is another wizard to help you create it by clicking on the [...] button in the above image.
|
