Using isql from the Command Prompt

Use the isql to verify the access service configuration.

Note: If you are using isql on the same machine on which you installed ECDA, you must add an access service entry to the interfaces file that points to the access service you are testing.

On the client machine, use dsedit to create an interfaces file entry for the access service.

Enter the access service name exactly as you defined it in the configuration file or by using DirectConnect Manager.
Set the environment variables from a command prompt by executing the appropriate script for your platform:
- DC_SYBASE.csh
- DC_SYBASE.sh
From the command prompt, enter:
```
isql -SServiceName -Uuserid -Ppassword
```
where:
- ServiceName is the name of the access service exactly as you defined it in the interfaces file.
- userid is a valid user ID for the target database.
- password is a valid password for the user ID in the target database.
If the connection is successful, you see a 1> prompt.

Note: If you cannot connect, the access service may not be running. Start the access service with DirectConnect Manager or edit the configuration file, and then verify that the EnableAtStartup parameter is set to Yes. This starts the access service automatically when the server is started.
At the 1> prompt, enter a select statement and press Return to query a table in the target database.
At the 2> prompt, enter:
```
go
```
Press Return.

The query should run and return a result set, followed by a 1> prompt.
To exit isql, enter:

1> prompt: exit

Press Return.

You see a regular operating system command.

Note: You can stop the DirectConnect server using the stopsvr utility, which shuts down the server and terminates all client connections. However, if you plan to perform postinstallation tasks for the client and server, leave both the DirectConnect server and access service running.