AcuODBC User's Guide
Version 6.0

9.2 Configuring the Remote DSN on a Windows Client

  1. Create a new DSN.
    1. Open the Windows control panel. Depending on which version of Windows you are running, either double-click the ODBC Data Sources icon or open the Administrative Tools folder and double-click Data Sources (ODBC).
    2. Select the User DSN, System DSN, or File DSN tab, and click Add. See section 3.1, "Data Source Names (DSNs)," for information on the types of DSNs.
    3. Choose AcuODBC Driver as the driver in the Create New Data Source dialog box, and then click Finish.

  2. On the General tab of the AcuODBC Configuration property sheet, specify only the Data Source Name.
  3. Select the AcuODBC Server tab.
    1. Select Remote SQL Processing.
    2. Enter the Host Name or the IP Address.
    3. The default Port Number is "0". If either 0 or 20222 is in this field, both the client and server will use 20222. Changing this number will change the port.
    4. If the data source is on a Windows server, select one of the following for the NT Security setting:
    5. If ...
      Then ...
      You want to use AcuODBC Server's security features
      Select None. AcuODBC Server uses the AcuAccess file to authorize the connection and manage file access.
      You want to use Windows NT's security system by connecting to the server via a named pipe. This method does not require the use of a password.
      Select Named Pipe. The password field in the AcuAccess file is ignored. The AcuODBC client connects to the AcuODBC server using a named pipe. This gives the client all the features of Windows NT file permissions. The client machine must have permission to create the named pipe. If the client does not have permission, both the client and server systems will hang. See your Windows NT documentation for information about permissions and named pipes. Note that Acucorp does not encourage the use of named pipes.
      You want to use Windows NT's security system by logging the user onto the Windows domain via a password. The password may be stored in the AcuAccess file or can be entered by the user directly.
      Select Logon. When "Logon" is selected, AcuODBC Server attempts to log the user onto the Windows NT domain using the password in the AcuAccess file. If there is no password or the password is not valid, the user is prompted to enter a password. "Logon" is frequently a simpler, more reliable connection method than a named pipe.

    See section 8.3, "System Security - The AcuAccess File," for more information.

  4. Click OK.

You have created the new DSN on the client. Proceed to section 9.3, "Configuring the Remote DSN on a Windows Server," for the next steps.

Acucorp, Inc.
Voice: (800) 262-6585 (U.S.A. and Canada)
Voice: (858) 689-4500
Fax: (858) 689-4550

Please share your comments on this manual
or on any Acucorp documentation with the
Acucorp Communications Department.
1988-2003 Acucorp, Inc.
All rights reserved.