ASE ODBC connection string parameters

The following table describes the key connection string parameters for connecting to ASE via the ODBC driver.

Basic settings

Parameter Description
Server The ASE server host name or IP address.
Port The port number for the connection. The default value is 5000.
Database The name of the database to connect to.
User ID The ASE username.
Password The ASE password.

Advanced settings

Parameter Description
AllowFixedTypes Controls how fixed and variable string/binary types are reported in metadata. By default, the driver returns SQL_VARCHAR, SQL_WVARCHAR, and SQL_VARBINARY for compatibility. Set to True to return fixed types (SQL_CHAR, SQL_WCHAR, SQL_BINARY).
AllowNullStringsInMetadata Allows substituting empty strings for metadata arguments that do not accept NULL. Enabled by default to avoid errors with some third-party tools.
EmptyStringsAsNullInMetadata Controls whether empty strings are treated as NULL values when retrieving metadata.
ConnectionTimeout Time, in seconds, to wait for a connection to open before terminating the attempt. The default value is 15.
IPVersion Specifies the Internet Protocol version to use: ivIPv4 (default), ivIPv6, or ivIPBoth (try IPv6 first, then IPv4 if needed).
MultipleConnections Enables or disables creating additional connections to support concurrent sessions, commands, and rowset objects.
ODBCBehavior Specifies the ODBC specification behavior expected by a third-party tool: 0 (default, tool-defined), 2 (force ODBC 2.x), 3 (force ODBC 3.x).
QuotedIdentifier Treats text enclosed in double quotes as identifiers to avoid conflicts with reserved words. When disabled (default), quoted text is treated as a string literal.
RegionalDateTimeSettings Uses local regional settings when converting date and time values to strings.
RegionalNumberSettings Uses local regional settings when converting numeric values to strings.
StringTypes Controls returned string types: Default (driver-defined), Ansi (SQL_CHAR, SQL_VARCHAR, SQL_LONGVARCHAR), or Unicode (SQL_WCHAR, SQL_WVARCHAR, SQL_WLONGVARCHAR).
AllCatalogs Retrieves and displays all available catalogs (databases or schemas, depending on the database system) from the connected server.

Sample connection string

DRIVER={Devart ODBC Driver for ASE};Server=your_ase_server;Database=your_database_name;Port=your_port_number;User ID=your_username;Password=your_password