Before you create your first DataWindow object, make sure that the DataWindow Designer plug-in 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 V110 DWD, are installed when you install DataWindow Designer.
To connect to the EAS Demo database:
Select View>DatabasePainter from the Visual Studio menu bar.
In the Objects view in the Database painter, right-click EAS Demo DB V110 DWD, and click Connect.
Troubleshooting tip
If you have uninstalled and reinstalled DataWindow Designer,
there might be an easdemo110.log file in the
DataWindow Designer directory. If you receive a SQLState error,
delete the log file and try to connect again.
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:
Select View>DatabasePainter from the Visual Studio menu bar.
In the Objects view on the left, expand the ODBC folder, expand Utilities, and double-click Create ODBC Data Source.
Select User Data Source and click Next.
Select SQL Anywhere 10.0 and click Next and then Finish.
On the ODBC page of the Connect to SQL Anywhere dialog box, type EAS Demo DB V110 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.5 directory.
Select easdemodb110.db, click Open, and then click OK.
This creates the EAS Demo DB V110 DWD DSN.
To create a database profile for the EAS Demo
database:
In the Objects view in the Database painter, right-click ODB ODBC and select New Profile.
In the Database Profile Setup dialog box, type EAS Demo DB V110 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.
