Configuring Pervasive.SQL ODBC

Article ID: 0501211501534 - Last Review: 03 June 2010 by jasonl - Revision: 2 - Views: 8057


About "Configuring Pervasive.SQL ODBC"
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:

  1. Install Pervasive.SQL, either Workgroup or Client
  2. Click Start | Control Panel | Administrative tools | Data sources (ODBC)
  3. In User DSN, click Add
  4. Select the Pervasive ODBC interface to use (either Client or Engine) and click Finish
  5. For Data Source Name, enter a descriptive name, eg, Service Accent database
  6. 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:

    1. Specify the server that your Service Accent database is held on
    2. Click Create to create a new data source
    3. In the Logon dialog, specify the server and your logon credentials
    4. Give this data source a name, eg Service Accent database
    5. Click Create to create a database
    6. In the Create database dialog, give the database a name, eg Service Accent
    7. Click Browse to locate the Service Accent dictionary (DDF) files. Locate your [Database] folder
    8. Click OK
    9. Click OK in the Modify Engine DSN dialog
    10. Click OK in the Pervasive ODBC Client DSN Setup dialog


  7. If you used the Engine interface, follow these steps:

    1. Click Create to create a database
    2. In the Create database dialog, give the database a name, eg Service Accent
    3. Click Browse to locate the Service Accent dictionary (DDF) files. Locate your [Database] folder
    4. Click OK
    5. 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).




 
 Related articles

Can not link to the WORK table using Pervasive.SQL ODBC
Unable to configure Pervasive.SQL ODBC via Remote Desktop
3103, 3012 or 3014 error when trying to access a Pervasive database
Can't start Pervasive Server Engine, Error 1069, login failure
Connecting to your Service Accent database via ODBC with Pervasive.V8 and later
Error message "1607:Unable to install InstallShield Scripting runtime" when trying to install Pervasive.SQL
Error message "DBU - Access Denied" when entering Pervasive.SQL license key
How to close Pervasive.SQL tables manually
How to configure Pervasive Backup Agent
How to disable the Local MicroKernel Engine under Pervasive.SQL V9
Installing Pervasive.SQL results in an 'Installation was interrupted' message

 Additional articles from the white papers

Pervasive Backup Agent v3
Service Accent - Installing Pervasive. SQL
Installing and configuring Pervasive. SQL 2000



For additional resources and information, you can go to the Service Accent Support Centre

Click here to go to the Service Accent Support Centre



Copyright © 2003-2018 Vantage Computing Ltd. All rights reserved. The information contained on this web site is correct as of its publication date.