9.2 Configuring the Remote DSN on a Windows Client

Create a new DSN.

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).

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.