Preparing to use the SQL Anywhere data source  Support for Transact-SQL special timestamp columns

Chapter 2: Using the ODBC Interface

Defining the SQL Anywhere data source

When you create a local SQL Anywhere database, DataWindow Designer automatically creates the data source definition and database profile for you. Therefore, you need only use the following procedure to define a SQL Anywhere data source when you want to access a SQL Anywhere database not created using DataWindow Designer on your computer.

StepsTo define a SQL Anywhere data source for the SQL Anywhere driver:

  1. Select Create ODBC Data Source from the list of ODBC utilities in the Database Profiles dialog box or the Database painter.

  2. Select User Data Source and click Next.

  3. On the Create New Data Source page, select the SQL Anywhere driver and click Finish.

    The ODBC Configuration for SQL Anywhere dialog box displays:

    The sample shows the ODBC page of the ODBC Configuration for Adaptive Server Anywhere dialog box. At top is the Data source name, shown as A S A 8 dot 0 Sample, and the Description Adaptive Server Anywhere Sample Database. Next are boxes for Translator and Isolation level, then check boxes for Microsoft applications, Prevent driver not capable errors, and Delay Auto Commit until statement close. Next is an area for Describing Cursor Behavior, with radio buttons for Never, If required, and Always. If required is selected. At bottom right is a Test Connector button.

  4. You must supply the following values:

    Use the Help button to get information about fields in the dialog box.

  5. (Optional) To select an ODBC translator to translate your data from one character set to another, click the Select button on the ODBC tab.

    See “Selecting an ODBC translator”.

  6. Click OK to save the data source definition.

Specifying a Start Line value

When the SQL Anywhere ODBC driver cannot find a running personal or network database server using the PATH variable and Database Name setting, it uses the commands specified in the Start Line field to start the database servers.

Specify one of the following commands in the Start Line field on the Database tab, where n is the version of SQL Anywhere you are using.

Specify this command

To

dbengn.exe

Start the personal database server and the database specified in the Database File box

rtengn.exe

Start the restricted runtime database server and the database specified in the Database File box

For information on completing the ODBC Configuration For SQL Anywhere dialog box, see the SQL Anywhere documentation.




Copyright © 2007. Sybase Inc. All rights reserved. Support for Transact-SQL special timestamp columns

View this book as PDF