dbExpress Driver and Framework support for SQL Anywhere 11

Go Up to Developing Database Applications for the Win32 Platform Index

RAD Studio XE provides support for the SQL Anywhere 11 from Sybase iAnywhere. Features include:

• New data types supported by SQL Anywhere 11, including NCHAR, NVARCHAR, and LONG NVARCHAR.
• New connection properties and attributes, including UNICODE metadata, include TABLE, FIELD, and INDEX name.
• NLS / UNICODE support for Adaptive Server Anywhere (ASA) 11.

Data types supported by the new ASA 11 driver

Starting with RAD Studio XE, there are new behaviors for old data types and new data types support is introduced. The following table lists the data types that are supported by version 11 of the iAnywhere driver along with their ASA 11 field wrapped types:

Data type	Field wrapped	Mentions
SQL_TYPE_NULL	fldASANULL	// 0
SQL_UNKNOWN_TYPE	fldASAUNKNOWN	// 0
SQL_CHAR	fldASACHAR fldASAUNIQUEIDENTIFIERSTR	// 1 // maxsize = 36
SQL_NUMERIC	fldASANUMERIC fldASAMONEY fldASASMALLMONEY	// 2 // 2 // 2
SQL_DECIMAL	fldASADECIMAL	// 3
SQL_INTEGER	fldASAINTEGER	// 4
SQL_SMALLINT	fldASASMALLINT	// 5
SQL_FLOAT	fldASAFLOAT	// 6
SQL_REAL	fldASAREAL	// 7
SQL_DOUBLE	fldASADOUBLE	// 8
SQL_DATE	fldASADATE	// 91
SQL_TIMESTAMP	fldASATIMESTAMP	// 93
SQL_VARCHAR	fldASAVARCHAR	none
SQL_DATETIME	fldASADATETIME fldASASMALLDATETIME	// 9 // DOMAIN
SQL_TIME	fldASATIME	// 92
SQL_TYPE_DATE	none	none
SQL_INTERVAL	fldASAINTERVAL	// 10 for ODBCVER >= 0x0300
SQL_TYPE_TIME	none	none
SQL_TYPE_TIMESTAMP	none	none
SQL_DEFAULT	fldASADEFAULT	// 99 for ODBCVER >= 0x0300
SQL_ARD_TYPE	fldASAARD	// -99 for ODBCVER >= 0x0300
SQL_BIT	fldASABIT fldASALONGVARBIT fldASAVARBIT	// -7
SQL_TINYINT	fldASATINYINT	// -6
SQL_BIGINT	fldASABIGINT	// -5
SQL_LONGVARBINARY	fldASALONGVARBINARY fldASALONGBINARY fldASAIMAGE	// -4 // maxsize = 2Gb
SQL_VARBINARY	fldASAVARBINARY	// -3
SQL_BINARY	fldASABINARY	// -2
SQL_LONGVARCHAR	fldASALONGVARCHAR fldASATEXT fldASAXML	// -1
SQL_WCHAR	fldASANCHAR fldASAWCHAR	// UTF-8 // -8
SQL_WVARCHAR	fldASANVARCHAR fldASAWVARCHAR	// UTF-8 // -9
SQL_WLONGVARCHAR	fldASALONGNVARCHAR fldASANTEXT fldASAWLONGVARCHAR	// UTF-8 // Unicode // -10
SQL_GUID	fldASAUNIQUEIDENTIFIER fldASAGUID	// -11 (UUID), maxsize = 36 // -11 for ODBCVER >= 0x0350

Connection Attributes

Another new feature in the support for SQL Anywhere 11 is represented by a number of new connection attributes. The connection attributes included in this release are listed in the following table:

Connection Attribute	ODBC Version
SQL_ATTR_ACCESS_MODE	ODBC 1.0
SQL_ATTR_AUTOCOMMIT	ODBC 1.0
SQL_ATTR_CONNECTION_DEAD	ODBC 3.5
SQL_ATTR_LOGIN_TIMEOUT	ODBC 1.0
SQL_ATTR_METADATA_ID	ODBC 3.0
SQL_ATTR_TRACE	ODBC 1.0
SQL_ATTR_TRACEFILE	ODBC 1.0
SQL_ATTR_TRANSLATE_LIB	ODBC 1.0
SQL_ATTR_TRANSLATE_OPTION	ODBC 1.0
SQL_ATTR_TXN_ISOLATION	ODBC 1.0

Follow Up

At clients' request, the following attributes may be implemented in the future:

Connection Attribute
allow_read_client_file
allow_write_client_file
AuthType
CacheReadWorkTable
ClientNodeAddress
DiskReadWorkTable
DiskSyncRead
DiskSyncWrite
DiskWaitRead
DiskWaitWrite
DiskWriteHint
DiskWriteHintPages
LockIndexID
LockRowID
max_priority
OSUser
priority
query_mem_timeout
QueryMemActiveCurr
QueryMemExtraAvail
QueryMemGrantFailed
QueryMemGrantGranted
QueryMemGrantWaiting
QueryMemGrantRequested
QueryMemWaited
ServerNodeAddress
ReadHint
ReadHintScatter

See Also

• dbExpress Supported Database Management Systems
• dbExpress Framework Compatibility
• Deploying dbExpress Database Applications