"Specified driver could not load due to a system error 1114 (Pervasive ODBC Client Interface)" error message when you try to create, test, or connect to a Pervasive ODBC Connection

SUMMARY


You receive a'Specified driver could not load due to a system error 1114 (Pervasive ODBC Client Interface)' error message when you try tocreate, test or connect to a Pervasive ODBC connection.


CAUSE


The \PVSW\Bin or the install directory for Pervasive.SQL components is not in the system path.


RESOLUTION


This frequently occursif a Novell/Windows login script overwrites the system path. You will have to modify the Novell/Windows Login script to include the C:\PVSW\BIN directory. Steps to update the Environment variables to include this path are available for the Windows XP, Windows 2000, Windows ME, Windows NT, Windows 98, and Windows 95 operating systems.


To change the Environment variables in
Windows XP, follow these steps:


1. Click Start, click Control Panel, and then double-click System.


2. In System Properties,click theAdvanced Tab, and then click Environment Variables.


3.Type a semicolon (;) at the end of the Path value, and then typeC:\PVSW\BIN.


Example If the Path value is Path=C:\Windows, after you make the changes in step 3, the Path value will bePath=C:\Windows;C:\PVSW\BIN.


NoteMake sure that you edit the Path variable in Systems Variables.System Variables is a global change where as User Variables is only for that user.


To change the Environment variables in
Windows 2000, follow these steps:


1. Click Start, click Settings, click Control Panel, and then double-click System.


2. In System Properties, click the Advanced tab,click Environment Variables,click to select the Path variables from the System Variables list, and then click Edit.


3.Type a semicolon (;) at the end of the Path value, and then typeC:\PVSW\BIN.


Example If the Path value is Path=C:\Windows, after you make the changes in step 3, the Path value will bePath=C:\Windows;C:\PVSW\BIN.


NoteMake sure that you edit the Path variable in Systems Variables.System Variables is a global change where as User Variables is only for that user.


To change the Environment variables in
Windows ME, follow these steps:


1. Click Start, click Run,typemsconfig.exe, and then click OK.


2. In the System Configuration Utility, click the Environment tab, click to select the Path variable, and then click Edit.


3. Type a semicolon (;) at the end of the Path value, and then typeC:\PVSW\BIN.


Example If the Path value is Path=C:\Windows, after you make the changes in step 3, the Path value will bePath=C:\Windows;C:\PVSW\BIN.


To change the Environment variables in
Windows NT, follow these steps:


1. Click Start, click Settings, click Control Panel, and then double-click System.


2. In Sytem Properties, click theEnvironment tab,click to select the Path variables from the System Variables list, and then click Edit.


3.Type a semicolon (;) at the end of the Path value, and then typeC:\PVSW\BIN.


Example If the Path value is Path=C:\Windows, after you make the changes in step 3, the Path value will bePath=C:\Windows;C:\PVSW\BIN.


NoteMake sure that you edit the Path variable in Systems Variables.System Variables is a global change where as User Variables is only for that user.


To change the system path in
Windows 95 and
Windows 98, follow these directions:


Note - If a Novell/Windows login script is not run, you must edit the Autoexec.bat file on the drive C.


1. Open the Autoxec.bat file in Notepad and add the following line directly below thePath= statement:


Set Path = "C:\PVSW\BIN; %PATH%"


Note - Make sure to include the quotation marks.


2. Restart the workstation.

This article was TechKnowledge Document ID:27581