| Navigation: SQL Drivers > SQLAnywhere Accelerator >====== SQLAnywhere Accelerator Connection Information and Driver Configuration–File Properties ====== |    |
Typically, you add SQLAnywhere support to your application by importing the table definitions into your Clarion Data
Dictionary. The Import Wizard automatically fills in the File Properties dialog with default values based on the imported item.
The default syntax of the Owner attribute for an SQL Anywhere table should be in the form of:
DatabaseName,UserName,Password
Example: asademo11,dba,sql
The database name should be the same as the server/engine name. If it is different, than the server/engine name must be passed later on in the string as documented by Sybase.
DatabaseName,Username,Password;ENG=Server;COMMLINKS=TCPIP(HOST=HostName)
Example: asademo11,dba,sql;ENG=demo11;COMMLINKS=TCPIP(HOST=CorpServer)
The Clarion SQL Anywhere driver needs to find the appropriate SQL Anywhere driver to use. It does this by searching the installed drivers on the machine which have either 'SQL Anywhere' or 'Adaptive Server Anywhere' in the text. The driver then reorders the list so that any driver containing 'Sybase SQL Anywhere' is used first, based on the version number in reverse order. The driver will try and raise a connection for each Sybase driver until it succeeds.
It is important to note that since the SQL Anywhere driver's initial task is to find the proper Sybase driver, that any 'DRIVER=' attribute on the connection/owner string is completely ignored. So for example, the following Owner string may connect to a different driver than what is specified:
asademo,dba,sql;DRIVER={Adaptive SQL Anywhere 9.0}
If both the SQL Anywhere 12 driver and the Adaptive SQL Anywhere 9.0 are installed on this machine, the SQL Anywhere 12 driver will be used even though another driver was specified.
This is usually not an issue since it's best to use the latest Sybase driver. The exception is when you need/want to specify a HOST/SERVER name; since the release of Sybase SQL Anywhere version 12, Sybase has changed how the HOST/SERVER is sent in the connection string, for example:
Sybase SQL Anywhere 11 and sooner uses: ;COMMLINKS=TCPIP(HOST=HOST/SERVER)
Sybase SQL Anywhere 12 and newer uses: ;HOST=HOST/SERVER
If you want to specify which driver to use and bypass the automatic driver selection,
simply start your connection string with ;UID= and this will tell the driver to ignore automatic driver selection.
Example:
Glo:dbowner = ';UID=asademo;PWD=sql;ENG=ASADEMO11;Driver={SQL Anywhere 11};COMMLINKS=TCPIP(HOST=CorpServer)'
Or
Glo:dbowner=';UID=asademo;PWD=sql;ENG=ASADEMO11;Driver={SQL Anywhere 12};SERVER=CorpServer'
Type an exclamation point (!) followed by a variable name in the Owner Name field of the File Properties dialog to specify a variable connect string rather than hard coding the connect string (OWNER attribute) . For example: !GLO:ConnectString.