The default odbc.ini file installed in the installation directory is a template in which you create data source definitions. You enter your site-specific database connection information using a text editor. Each data source definition must include the keyword Driver=, which is the full path to the driver.

The following examples show the minimum connection string options that must be set to complete a test connection, where xx represents iv for 32-bit or dd for 64-bit drivers, yy represents the driver level number, and zz represents the extension. The values for the options are samples and are not necessarily the ones you would use. 

[ODBC Data Sources]
SQL Server Wire Protocol=DataDirect 8.0 SQL Server Wire Protocol
[SQL Server Wire Protocol]
Driver=ODBCHOME/lib/xxsqlsyy.zz
Database=default
HostName=SSServer
PortNumber=1433

Connection Option Descriptions:

Database: The name of the database to which you want to connect by default.

HostName: Either the name or the IP address of the server to which you want to connect:
  • If your network supports named servers, you can specify an address as: server_name. For example, you can enter SSserver.
  • If your network supports named instances of Microsoft SQL Server, you can specify this address as: server_name\instance_name. If only a server name is specified with no instance name, the driver uses the default named instance on the server.

PortNumber: The port number of the server listener. The default is 1433.