To Set Up a Direct SQL Server Configuration Using OLE DB

1. At the Command prompt, enter dbconnect.
2. On the dbConnect Manager, right-click Data Sources and click Configure Data Source.
3. In the Configure a Data Source dialog box, do one of the following:
   • Create a data source. In the Data Source Name box, enter a name for the data source. Click OK.
   • Edit an existing data source. In the Data Sources list box, select a data source. Click OK.
4. In the Data Link Properties dialog box, Provider tab, select Microsoft OLE DB Provider for SQL Server. Click Next.
5. In the Select or Enter a Server Name box, enter the server name.
6. In the User Name and Password boxes, enter a valid user name and password.
7. In the Select the Database on the Server box, select the database to configure.
8. Click Test Connection to verify that the settings are correct. For example, spelling errors and case sensitivity may be the cause of a failed connection.
9. Click OK.