Before you create your first DataWindow object, make sure that DataWindow Designer is connected to the EAS Demo database. This database contains tables that are used as examples in the DataWindow Designer User’s Guide. An ODBC data source and database profile, both named EAS Demo DB V105 DWD, are installed when you install DataWindow Designer.
If you do not have an ODBC data source or a DataWindow Designer database profile for this database, use the following procedures to create them. If you already have the data source and profile, look at step 2 in the second procedure to see a quick way to code the connection syntax in your .NET application.
To create a data source for the EAS Demo database:
Click the Database Profile button on the PowerBar, expand the ODBC folder, expand Utilities, and double-click Create ODBC Data Source.
Select User Data Source and click Next.
Select Adaptive Server Anywhere 9.0 and click Next and then Finish.
On the ODBC page of the Connect to Adaptive Server Anywhere dialog box, type EAS Demo DB V105 DWD as the name of the data source.
On the Login page, enter dba as the User ID and sql as the Password.
On the Database page, click Browse and navigate to the DataWindow Designer 2.0 directory.
Select easdemodb105.db, click Open, and then click OK.
This creates the EAS Demo DB V105 DWD DSN.
To create a database profile for the EAS Demo
database:
In the Database Profile dialog box, select ODBC ODB and click New.
In the Database Profile Setup dialog box, type EAS Demo DB V105 DWD as the name of the profile, select the EAS Demo DB DSN you just created, and click Apply.
That is all you need to do to create a profile, but while you have the dialog box open, click the Preview tab. The Database Connection Syntax box contains code you can copy and paste into your .NET application. You can change the name of the transaction object you use to connect to the database and your programming language.
Click OK.
To connect to the EAS Demo database:
In the Database Profile dialog box, expand the ODBC folder, select the EAS Demo DB V105 DWD database profile, click Connect, and then click OK.
