Configuring a Data Source in the System Information File
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.
If your network supports named servers, you can specify an address as: server_name. For example, you can enter SSserver.