iAnywhere Solutions ODBC Drivers
  iAnywhere Solutions ODBC Driver for Sybase Adaptive Server Enterprise

Configuring data sources

On Windows, data sources are configured and modified through the ODBC Administrator.

To configure a Sybase Adaptive Server Enterprise data source (UNIX)

• In the UNIX environment, there is no ODBC administrator. To configure a data source in the UNIX environment, you must edit the system information file.

  For information about editing this file, see Quick start for UNIX.

To configure a Sybase Adaptive Server Enterprise data source (Windows)

1. Start the ODBC Administrator to display a list of data sources.

2. If you are configuring an existing data source, select the data source name and click Configure to display the Adaptive Server Enterprise Driver Setup dialog box.

3. If you are configuring a new data source, click Add to display a list of installed drivers. Select the iAnywhere Solutions 9 - Sybase ASE driver and click Finish to display the Adaptive Server Enterprise Driver Setup dialog box.

4. On the General tab, provide the following connection information and then click Apply.

   • Data Source Name    Type a string that identifies this Adaptive Server Enterprise data source configuration in the system information. Examples include Accounting or Sys11-Serv1.

   • Description    Type an optional long description of a data source name. For example, My Accounting Database or System 11 on Server number 1.

   • Network Library Name    Select the name of the network library. This specifies which network protocol to use. The values are Winsock and NamedPipes.

   • Network Address    Type the network address. The value you specify depends on which network protocol is chosen under Network Library Name and on the Adaptive Server Enterprise server.

     If you choose Winsock for the Network Library Name, specify an IP address as follows: servername-or-IP-address, port-number. For example, if your network supports named servers, you may specify an address such as Sybaseserver, 5000. You may also specify the IP address directly such as 199.226.224.34, 5000.

     If you choose NamedPipes as the network protocol, you must specify the pipe address of the server. For example, \\machine1\sybase\pipe\query.

   • Database Name    Type the name of the database to which you want to connect by default. If you do not specify a value, the default is the database defined by the system administrator for each user.

5. Configure other settings in a manner appropriate for your application.

   Most settings can be left at their default values. For a list of key driver settings when using MobiLink, see Key driver settings for MobiLink.

6. At any point during the configuration process, you can click Test Connect to attempt to connect to the data source using the connection properties specified in the Driver Setup dialog box. A logon dialog box is displayed. For more information, see Connecting to a data source using a logon dialog box. Note that the information you enter in the logon dialog box during a test connect is not saved.

   • If the driver can connect, it releases the connection and displays a "connection established" message. Click OK.

   • If the driver cannot connect because of an improper environment or incorrect connection value, it will display an appropriate error message. Click OK.

7. Click OK or Cancel. If you click OK, the values you have specified become the defaults when you connect to the data source. You can change these defaults by using this procedure to reconfigure your data source. You can override these defaults by connecting to the data source using a connection string with alternate values.