As mentioned earlier, the ODBC list contains DSNs (data source names) or actual ODBC data sources. The DSNs are packages containing instructions and database drivers that create the connection to a database. If you do not see a data source already set up for your database, you have two options. One is to select die DSN from the list that is correct for your type of database, and connect it to your database. The other option is to create a new DSN, and use it to set up a connection to your database. Both methods are outlined in the next section. Once the connection is made, you can save the connection to the Favorites folder for future use. You only have to set up the data source once.
Connecting to a Database with an Existing ODBC DSN
Setting up a new ODBC data source using an existing DSN resembles setting up a Database File connection.
With the Data Explorer open, click ODBC. This expands a list of DSNs
Select one of the DSNs form the list that coincides with your database. For example, you would select CRSS to connect to SOJ-. Server, CROR7 for Oracle 7, or Excel Files to connect to an Excel Workbook. Click the plus sign. This will open a dialog box or wizard that is specific to whatever DSN. You have used. It may be a Select Database dialog box, or File Open, Server Login, etc. What opens is dependent on the database and has nothing to do with SCR.
Depending on which DSN you selected, follow the prompts, which are databasing dependent, complete the log in information, or whatever you are asked for. Once you click OK or Done, you will be back in the Data Explorer with tables listed under the DSN name that you first selected. You are now ready to select tables for a report.
This method of creating an ODBC data source works, but you will need to follow these steps each time you open SCR to design a report. You could add the connection to your favorite’s folder, so it is saved, but you ate not able to give it a name. What happens if you are using two MS Access databases? You will want to consider the following suggestion, which is to set up a new data source,