Connecting to your Service Accent database via ODBC with Pervasive.V8 and later

Article ID: 060619122555 - Last Review: 27 May 2008 by jasonl - Revision: 8 - Views: 10079


About "Connecting to your Service Accent database via ODBC with Pervasive.V8 and later"
This article describes how to use the ODBC drivers included in Pervasive.V8 and later to connect to, and pull data from, your database. The security model in Pervasive.V8 and later changes slightly from earlier versions which necessitates extra steps.

This procedure will modify the database dictionary (DDF) files which will cause Service Accent to generate errors if you do not follow the instructions correctly


  1. Use Windows Explorer to create a new folder in your AccentDB folder called ODBC
  2. Use Windows Explorer to copy all the files with a .DDF extension from your AccentDB folder to the AccentDB\ODBC folder

    Service Accent version 4.11.203 and later removes the security from the DDF files. If you are running this version or a later version of Service Accent please go straight to step 5

  3. At this point, you need to get to the command prompt and change to your AccentDB\ODBC folder
  4. While you are in the AccentDB\ODBC folder, type the following:

    for %a in (*.ddf) do butil -save %a %~na.sav

    for %a in (*.ddf) do butil -clone %~na.new %a

    for %a in (*.ddf) do butil -load %~na.sav %~na.new

    del *.ddf

    ren *.new *.ddf

    This step will remove the existing security from DDF files in the AccentDB\ODBC folder
  5. You must now create the ODBC connection. Click Start | Control Panel | Administrative Tools | Data Sources (ODBC)
  6. Click on the System DSN tab
  7. Click Add...
  8. Select Pervasive ODBC Client Interface
  9. Click Finish
  10. Give the data source a name, for example, "Service Accent Client"
  11. In the Server section, enter your server's name
  12. Click Create... to create a new connection on the server
  13. In the Logon dialog, enter your usual logon credentials for that server
  14. Give the data source a name, for example, "Service Accent Engine"
  15. Click Create... next to Database Name
  16. Give the database a name, for example "Service Accent"
  17. Ensure Integrity Enforced is ticked and Bound (DDFs created) is unticked
  18. The Btrieve security policy should be set to Database (DB authentication and authorization)
  19. Click Browse... in Dictionary location and select your AccentDB\ODBC folder
  20. You will see that the default folder of AccentDB\ODBC has been added to the Data File Locations. Highlight this and click Delete
  21. Click Add... and select your AccentDB folder

    At this point, the Create Database window should resemble the following:




  22. Click OK

    At this point, the Create Engine DSN window should resemble the following:





  23. Click OK

    At this point, the Pervasive ODBC Client DSN Setup window should resemble the following:




  24. Click OK
  25. Click OK to quit the ODBC Data Source Administrator

That completes the creation of an ODBC connection to your database.

Please note that if you apply an update to Service Accent that updates your database, you will need to repeat steps 2 through 4 so as to use the latest Database Dictionary Files. If you do not do this, your application will attempt to connect to your Service Accent database using out-of-date database definitions and you may receive errors.


 
 Related articles

3103, 3012 or 3014 error when trying to access a Pervasive database
Can not link to the WORK table using Pervasive.SQL ODBC
Can't start Pervasive Server Engine, Error 1069, login failure
Configuring Pervasive.SQL ODBC
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
Message 'Setup has detected that unInstallShield is in use' when installing Pervasive.SQL 2000i
Pervasive.SQL error 2 using Windows Server 2003 and Pervasive.SQL Server Edition
Pervasive.SQL returns a status of 46 when starting Service Accent
Pervasive.SQL V8 compatibility
Resolving Pervasive status 84
Resolving Pervasive.SQL status 3012 and 3014 (Part 2)
Running Pervasive.SQL V8 Server Edition on a Windows XP Professional platform
Running the Pervasive.SQL server engine under Windows Server 2003
Status 94 with Pervasive.SQL Server on Windows NT, 2000, 2003
Unable to configure Pervasive.SQL ODBC via Remote Desktop
Unable to connect to Pervasive.SQL Monitor remotely
Using Pervasive.SQL on a 64 bit CPU
Windows NT 4 Server with Windows 2000 clients and Pervasive.SQL 2000 Server

 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.