ORA-12571: TNS packet writer failure

Posted on 2004-11-23
Last Modified: 2013-12-12
Hi everyone, ive developed a fleet tracking software using VB6 and Oracle 9i. Ill give u a brief desc of how the software works. Each vehicle is fitted with a firm wear which gives its position every 5 minutes to our main server. The server then sends this information to the customers via their username and password. The software then picks up this information, places the vehicle on the map and then stores the details in the oracle database which is always held locally on the PC. Thats the gist of it. The problem im having is anytime the cable that connects the PC to the internet is removed, the software crashes with the above error message. Ive stepped throught the code and it errors when i try to create a recordset using data from the oracle database while the cable has been disconnected. But if i try runing the same SQL statement in SQLplus while the same cable has been disconnected, it works fine. Any ideas as to why this is happening?  
Question by:oagunbiade
    LVL 7

    Accepted Solution

    If you catch the error and retry the recordset creation after the cable is connected, does the error still occur?
    Could you post the section of code in question?

    Author Comment

    If i retry the recordset creation after the cable is connected, the error still occurs. But ive found a way round this. Because the error generates a unique code, i recreate the connection any time the error is generated and this works fine. Thanks anyways.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    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…
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    794 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

    16 Experts available now in Live!

    Get 1:1 Help Now