Connect to Sybase SQL Anywhere (AnyDAC)
From RemObjects Software
This is a AnyDAC Database Connectivity entry
Feel free to add your notes to this topic below.
Contents |
Supported versions
The AnyDAC native driver supports Sybase SQL Anywhere version 7 and higher.
Client software
AnyDAC requires one of the Sybase SQL Anywhere ODBC drivers to be installed on workstation:
- "Adaptive Server Anywhere" ODBC driver to connect to v 7.
- "SQL Anywhere N" ODBC driver, where N is the DBMS major version number (e.g. 8, 9, 10).
The preferred driver is "SQL Anywhere N". The ODBC driver is part of Sybase SQL Anywhere SDK. You can download it from here.
Connection definition parameters
DriverID=ASA
|
Parameter |
Description |
Example value |
|---|---|---|
|
Server |
Specifies the name of a running database server to which you want to connect. |
ASASrv |
|
Database |
Identifies a loaded database to which a connection needs to be made when connecting to a database that is already running. |
|
|
OSAuthent |
If Yes, then an integrated login is attempted. |
No |
|
UserName |
Specifies the user ID used to log in to the database, if OSAuthen=No. |
dba |
|
Password |
Specifies the user password used to log in to the database, if OSAuthen=No. |
sql |
|
DatabaseFile |
Indicates which database file you want to load and connect to when starting a database that is not already running. If you want to connect to an already-running database, use the Database parameter. |
|
|
App |
Assists administrators in identifying the origin of particular client connections from a database server. The string can be retrieved using the statement: SELECT CONNECTION_PROPERTY('AppInfo') |
|
|
Compress |
Specify Yes to turn compression on for a connection or No to turn off. By default it is turned off. |
Yes |
|
Encrypt |
Encrypts packets sent between the client application and the server using transport-layer security or simple encryption. The value syntax is { NONE | SIMPLE | TLS( TLS_TYPE=cipher; [ FIPS={ Y | N }; ] TRUSTED_CERTIFICATES=public-certificate ) } |
|
|
LoginTimeout |
Controls the amount of time in seconds an application waits for a connection attempt to timeout while waiting to establish a connection (0 specifies an infinite wait). |
30 |
|
ODBCAdvanced |
Allows to specify any other additional ODBC connection parameter value. The default value is "CommLinks=ShMem,TCP". Note, if CommLinks is specified, then server will not auto start. |
AutoStart=Yes;CharSet=Windows-1251 |
|
MetaDefCatalog |
Default database name. Design time code will exclude catalog name from object name, if it is equal to MetaDefCatalog. |
addemo |
|
MetaDefSchema |
Default schema name. Design time code will exclude schema name from object name, if it is equal to MetaDefSchema. |
dba |
Usage cases
- Auto start local server and open database file "C:\sybase\addemo_asa10.db":
DriverID=ASA ODBCAdvanced=AutoStart=Yes DatabaseFile=C:\sybase\addemo_asa10.db User_Name=dba Password=sql MetaDefSchema=dba
- Connect to default local server
DriverID=ASA User_Name=dba Password=sql MetaDefSchema=dba
- Connect to database ADDemo, running on server instance ASASrv:
DriverID=ASA Server=ASASrv Database=ADDemo User_Name=dba Password=sql MetaDefSchema=dba
- Connect to database ADDemo, running on server instance ASASrv in other network:
DriverID=ASA ODBCAdvanced=CommLinks=tcpip(host=227.12.66.1) Server=ASASrv Database=ADDemo User_Name=dba Password=sql MetaDefSchema=dba
See Also
- AnyDAC Database Connectivity
- AnyDAC FAQs
- How to configure AnyDAC Drivers
- How to manage AnyDAC Connection Definitions
Glossary — Features — How To — Components — Tools — Samples — Articles — Architecture — Issues
