Posted on 2005-04-20
Last Modified: 2013-12-25
Where to start..?

ok, I have say 200 servers all running pervasive v8.
These 200 servers are sequentially named:
using an asp page I've created a loop with the following DSN:

Driver={Pervasive ODBC Client Interface};Name=<<Server>>;DSN=@default;
(<<server>> being the current server in the loop).

which cycles through the list. makes a connection pulls a record back from a table and if successful writes a line to say the connection is okay.

Most are working fine, however,
I am finding that certain servers are making the connection 'Freeze' when instead I want it to write a line to say the connection is failing. I dont' even get an error, it just loads the page forever.
Having tried to manually script Command/Server/Script Timeouts and failing miserably was wondering if it is possible to kill the DSN, create output to tell me that and then move on to the next record.

I don't know if this is possible but would be very grateful for any help given.

    LVL 18

    Expert Comment

    What's different about the servers that "freeze"?  Are they a different version of Pervasive?  What are you trying to do with this script overall?  It might be worthwile to create either an ISAPI extension or an COM component that does the connection.  

    Author Comment

    Theoretically all installs of pervasive are the same. The servers are hardware equal. The only difference being some are on 2k and some on 2003 although the freezing is completely random and only happens on a few. I can dial into them and run psa but it shows everything's ok.

    I'm writing web applications to show a remote server's live data. I wanted to run a quick script that would both populate a sql table with all responding dsns and allow the users to select servers based on that list. At the same time I wanted to send automatic notifications or populate another column of the sql table and generate a second page that would notify our IT dept that there are connectivity issues with the select few servers.

    Since I'm really only proficient with vbscript in asp I wouldn't know where to start with writing a com or other types of extension.

    I'll go check them out. Thanks for the advice thus-far
    LVL 18

    Accepted Solution

    You might want to check that the few that are giving problems have the same Pervasive patch level. I see you're using V8, make sure you're at SP2 (8.6) at the client and the server.  For developing other extensions, I've gotten good information from:
    Another thing to try is to access the problematic servers on their own to try to determine what's happening.  

    Author Comment

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Pervasive][ODBC Client Interface][Client LNA]The ODBC Client Interface cannot access the data source because SQL Connection Manager is not running at the specified port number. Contact your system administrator for assistance.

    /corder/pervasive.asp, line 25

    The above error came up after the page ran/"froze" for about an hour. Is there a way I can force this to timeout after say, 20 seconds, post a result and then movenext?

    Thanks for the link. I had a quick peruse but am forced to carry on with another task so I shall resume reading later.



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Introduction: I have seen many questions on EE and elsewhere, asking about how to find either gaps in lists of numbers (id field, usually) ranges of values or dates overlapping date ranges combined date ranges I thought it would be a good …
    I guess that all of us know that caching the data usually increase the performance, but I worried if all of us are aware about the risk that caching the data provides and how to minimize this.  That’s the reason why I decided to write this short art…
    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…

    779 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

    12 Experts available now in Live!

    Get 1:1 Help Now