• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1914
  • Last Modified:

Pervasive Control Center

Hi,

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.
0
cjroberts77
Asked:
cjroberts77
  • 3
  • 2
1 Solution
 
mirtheilCommented:
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.  
0
 
cjroberts77Author Commented:
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
0
 
mirtheilCommented:
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)?  
0
 
cjroberts77Author Commented:
*************** Log started ***************


Tuesday, 12 April 2005 02:00:48 PM  ---
****************
[ANALYZE SYSTEM]
****************
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
0
 
mirtheilCommented:
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 (http://www.pervasive.com).
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now