• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1969
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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