Service Accent knowledge base

Unable to configure Pervasive.SQL ODBC via Remote Desktop

Article ID: 100513143335 - Last Review: 13 May 2010 by jasonl - Revision: 1 - Views: 4518

Symptom

If you try and configure an ODBC connection via Remote Desktop, you may receive an error warning you that you have insufficient permissions.

Cause

Under Remote Desktop, Pervasive.SQL and its associated applications assume restricted permissions. This means that installation and configuration of Pervasive.SQL and associated applications (including ODBC) under Remote Desktop may not be possible.

Solution

You can force Pervasive.SQL to assume correct permissions under Remote Desktop by modifying the following key using regedit.exe:

HKEY_LOCAL_MACHINE\Software\Pervasive Software\Utilities Interface\Settings\Restricted Access on WTS Client

And chaging the default value of 1 to 0

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

•	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

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

Click here to go to the Service Accent Support Centre