Before you define and connect to a SQL Anywhere data source in DataWindow Designer, follow these steps to prepare the data source.
To prepare a SQL Anywhere
data source:
Make sure the database file for the SQL Anywhere data source already exists. You can create a new database by:
Launching the Create SQL Anywhere Database utility. You can access this utility from the Utilities folder for the ODBC interface in the Database profile or Database painter when DataWindow Designer is running on your computer.
This method creates a local SQL Anywhere database on your computer, and also creates the data source definition and database profile for this connection. (For instructions, see the User’s Guide.)
Creating the database some other way, such as with DataWindow Designer running on another user’s computer or by using SQL Anywhere outside DataWindow Designer. (For instructions, see the SQL Anywhere documentation.)
Make sure you have the log file associated with the SQL Anywhere database so that you can fully recover the database if it becomes corrupted.
If the log file for the SQL Anywhere database does not exist, the SQL Anywhere database engine creates it. However, if you are copying or moving a database from another computer or directory, you should copy or move the log file with it.
