Configuring the ADO Client : Using Interactive SQL for ADO : Example of an Interactive SQL Session

Example of an Interactive SQL Session

The following example assumes an OpenAccess SDK Server is running on a host mysdkserver at port 19986 and is configured with the Default server data source.

1. Start the ISQL tool. Do one of the following:

a. On Windows, select Progress DataDirect OpenAccess Client for ADO SDK 8.1 / Interactive SQL (OLE DB).

b. From a command prompt set to the installation subdirectory, type odedbisql.exe.

The Interactive SQL prompt appears.

2. From the Interactive SQL prompt, type:

CONNECT

3. The Data Link Properties dialog box appears.

4. From the Data Link Properties dialog box, select DataDirect OpenAccess SDK for ADO 8.1 Provider and then click Next.

5. Click the All tab and edit the Extended Properties attribute to the string to specify the host, port and the ServerDataSource. For example, type:

host=mysdkserver;port=19986;ServerDataSource=Default;

6. Click the Connection tab. Provide the following information:

Data Source: Type the name of a data source (see Creating an ADO Client Data Source).

User name: Type the user name.

Password: Type the password.

7. Select Test Connection.

8. Click OK to return to the ISQL prompt.

9. From the Interactive SQL prompt, enter in a SQL query. For example, type:

SELECT * FROM emp;

10. From the Interactive SQL prompt, type:

EXIT