This article describes how to configure the Pervasive.SQL ODBC driver in Pervasive.SQL 2000i and earlier to access your Service Accent database.
Please note: The default ODBC configuration allows full and unrestricted access to the Service Accent database. We recommend you exercise extreme caution in the deployment of an ODBC link as the data integrity rules built in to Service Accent will be bypassed completely.Follow these steps in order to configure Pervasive.SQL ODBC:
- Install Pervasive.SQL, either Workgroup or Client
- Click Start | Control Panel | Administrative tools | Data sources (ODBC)
- In User DSN, click Add
- Select the Pervasive ODBC interface to use (either Client or Engine) and click Finish
- For Data Source Name, enter a descriptive name, eg, Service Accent database
- If you used the Client interface, you will need to create an ODBC data source on the server as well one on your local PC. Follow these steps:
- Specify the server that your Service Accent database is held on
- Click Create to create a new data source
- In the Logon dialog, specify the server and your logon credentials
- Give this data source a name, eg Service Accent database
- Click Create to create a database
- In the Create database dialog, give the database a name, eg Service Accent
- Click Browse to locate the Service Accent dictionary (DDF) files. Locate your [Database] folder
- Click OK
- Click OK in the Modify Engine DSN dialog
- Click OK in the Pervasive ODBC Client DSN Setup dialog
- If you used the Engine interface, follow these steps:
- Click Create to create a database
- In the Create database dialog, give the database a name, eg Service Accent
- Click Browse to locate the Service Accent dictionary (DDF) files. Locate your [Database] folder
- Click OK
- Click OK in the Pervasive ODBC Engine DSN Setup dialog
You can now use this ODBC interface to access your Service Accent database using the ODBC username and password supplied to you by your support provider (if required; the database username and password security was removed in later versions of Service Accent).