Configuring ODBC Database Service Entries without a DSN

A description of how to configure ODBC service entries without a DSN.

When you configure this type of connection, you do not define the DSN or specify the user name and password in separate preferences. Instead, all connection-related information is collected in a single connect string.

For example, a c8-services.xml entry for an SQL Server database may look like:

<Service Name="MyDSN" Type="DATABASE" >
<Param Name="DBDriverType">DBDriverODBC</Param>
<Param Name="DBDriverConnectString">Driver=
   {SQLServer};Server=myServerAddress;Database=myDataBase;
   Uid=myUser name;Pwd=myPassword;</Param>
<Param Name="CacheMaximumAge">0</Param>
...
</Service>

For connect string format requirements for different databases, see http://www.connectionstrings.com. All other service entry preferences are described in "Configuring Connections to Databases with User Name, Password, and DSN".

Before connecting to ODBC databases by this method, Sybase recommends that you first make sure that your computer's client library can find the ODBC driver (which is not part of the CEP Engine software suite). On Microsoft Windows the driver is located in the registry, while on UNIX-like operating systems, the driver is located in the odbcinst.ini file. Since your database vendor may provide utilities for connecting to your ODBC database that don't themselves use ODBC, Sybase recommends that you test the ODBC connection through a universal data access (UDA) tool.