Knowledge Base Article #122 - Error occured initializing security. Execution Ending.
DateSep 22, 2006
ByRoss P
Filed UnderPowerBase Install
ClassGeneral
 
Issue Addressed
After installation of PowerBase, the user recieves the following error when trying to launch Pbase.exe.

"Error occured initializing security. Execution Ending."

 
Causes of Issue
This error is typically caused when PowerBase cannot connect to the PowerBase database. This is usually due to problems with drivers, DSN's or PBase.ini
 
Solution to this Issue
Drivers
Many times problems are caused by drivers. ENOSERV PowerBase installs a shortcut under the Programs > Enoserv > PowerBase entry in the Start Menu labeled 'Check Installed OLE Providers'.

Under the 'Provider' tab, make sure 'Sybase Adaptive Server Anywhere OLE DB Provider 9.0' is listed for Sybase users, and 'Oracle Provider for OLE DB' is listed for Oracle users. If not you will need to have this driver installed before PowerBase can run.

The drivers are generally installed as a part fo your database engine. For Cascade users, please see the section below.

Oracle Users
Most issues from Oracle installs occur in the pbase.ini file. Look for the file pbase.ini in your PowerBase install directory, located at 'c:\Program Files\Enoserv\PowerBase' by default. Open the file in your favorite text editor.

Verify the existance and settings of the following lines.

[Locations]
PBDatabaseType=ORACLE
SERVERNAME= The Name of your Oracle Server currently running the PowerBase database
USERNAME=PB

All other lines under the [Locations] heading should either be rem'd out or deleted.

Sybase ASA Users
Make sure your pbase.ini file, located in your install directory has the following lines:

[Locations]
PBDatabaseType=SYBASE
ASA_DSN=PBase4Eno
USERNAME=PB

(ASA_DSN=Pbase4Eno may be ASA_DSN=ENO_CAS if integrating with Cascade )

Next, go to your ODBC Administrator, under Control Panel -> Administrative Tools -> Data Sources (ODBC). Under the System DSN tab, there should be an entry for PBase4Eno ( Or ENO_CAS if integrating with Cascade by Digital
Inspections ). Click that entry and hit 'Configure'.

Under the ODBC Tab -
Ensure that the Delphi Applications box is checked.

Under the Login tab -
Make sure the username and password are entered. If they are not entered, contact ENOSERV for the proper entries.

Under the Database tab (For servers)-
Make sure the server field is blank. And that the database file field points to the *.db file you wish
to use.

Under the Database tab (For Clients)-
Make sure the field labeled 'Server Name', contains the name of your PowerBase server and the server is running. If there is an entry in the field labeled 'Database File', delete it.

Under the Network tab (For Servers) -
Make sure the TCP/IP box is unchecked.

Under the Network tab (For Clients) -
Make sure the TCP/IP box is checked.

Under the 'ODBC' Tab -
Press the Test Connection button. If the connection fails, double-check all the entries were entered correctly.


If The Above Procedure Still Results in an Error

Make sure you can connect to your database, using an external tool, such as Sybase Central or TOAD. Sometimes the issue can be within the database engine, or with a corrupt database file.

 
Other Comments
If you are a Cascade user and the above procedure still resultsin the error, please refer to this article.

Login to Support
Email:
Password:
Contact Support to reset your password

Support Links
Support Main
Register for Support
Knowledge Base

Contact Support
Phone:
(918) 622-4530
. . . . . . . . . . . . . . . . .
Email:
[email protected]