Pervasive Control Center

Posted on 2005-04-11
Last Modified: 2013-12-25

We are using Pervasive V8 and can't seem to open up any of the databases. We are getting "Connection to the database ... failed" with the following detailed description...

[Pervasive][ODBC Client Interface][Client LNA]Connection attempt timed out.  The SQL Connection Manager may be inactive or using a different transport protocol from the client.

Any ideas/suggestions would be appreciated as we use Pervasive for our Payroll.
Question by:cjroberts77
    LVL 18

    Expert Comment

    Where's the data?  Make sure both the relational and transactional engines are running (on Windows, check the services.  on NetWare make sure mgrstart and bstart have been run).  Also, run the PSA (Pervasive System Analyzer) to make sure you have network connectivity.  

    Author Comment

    Both relational and transactional engines are running. PSA really didn't give us any valuable information...
    We have noticed that Pervasive becomes unstable when certain crystal reports are executed
    LVL 18

    Expert Comment

    Did PSA actually run and show that both the transactional and relational engines were running?  If not, then that's pretty valuable.  Post your PSA log (c:\program files\common files\pervasive software shared\psa\psalog.txt).  
    What do you mean by "unstable"?  Have you restarted the engine (both relational and transactional)?  

    Author Comment

    *************** Log started ***************

    Tuesday, 12 April 2005 02:00:48 PM  ---
    Target Machine Name: machine_name
    Analyzing the system...

    Tuesday, 12 April 2005 02:00:48 PM  ---Looking in system directory for Pervasive files.

    Tuesday, 12 April 2005 02:00:48 PM  ---Looking in PATH for Pervasive files.

    Tuesday, 12 April 2005 02:00:48 PM  ---Looking for PVSW\BIN directory.

    Tuesday, 12 April 2005 02:00:48 PM  ---Looking in the registry for Pervasive product install directory.

    Tuesday, 12 April 2005 02:01:02 PM  ---Analysis of the system completed.

    Tuesday, 12 April 2005 02:01:53 PM  ---

    *************** Log ended ***************

    When the server is re-booted, Pervasive becomes stable and usable
    LVL 18

    Accepted Solution

    THe log doesn't show any of the network connectivty tests or the transactional or relational tests.  Looks like you haven't run them.  
    If Crystal is causing a "stability" issue, pull the SQL query out and rerun it in the PCC. If it still causes a "stability" issue, open a support ticket with Pervasive.
    Also, make sure you are using Pervasive.SQL V8.6 (SP2) available from Pervasive's web site (

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    This article describes some very basic things about SQL Server filegroups.
    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now