Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    2

    Unanswered: Visual Basic application login to remote database server

    I am using Informix Dynamic Server 7.31 on a Siemens machine at a remote office. The remote office is link with my central office through routers and digital leased line with a backup ISDN line. The ISDN line will take-over the leased line when the leased line failed to function. Typically, it will take less than a minute for the ISDN line to replace the leased line as the primary line.
    Using MS Visual Basic, I have developed an application that logs in to the remote machine database. My application is running on a Windows-based computer and it works fine.
    The problem - when the leased line breaks down and the ISDN line begins to take over, my application will terminate and Dr. Watson message will appear. It seems to me, the problem happens because there is a delay for the ISDN to take over and the delay causes the application to terminate.
    Is there somthing that I can tune in my VB application or the Informix server to be able to handle telecommunication line problem better?

    Thanks in advance.
    PL

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Do you test whether the connection is active in your visual basic program?
    You could check what happens if you f.ex. unplug your windows machine from the network what error it generates on the ODBC level.
    You could then test in your application for that error code and then reconnect.

    If that doesn't work, trace the connection with sqlidebug to find out why VB crashes with Dr Watson.
    rws

  3. #3
    Join Date
    Dec 2002
    Location
    Pakistan
    Posts
    31
    MS VB application will generate error whenever network problem occurs/database down while db connection are active.

    It depends on the ODBC driver and logic of your application how to handle this situation.

    Did you try to inactivate your db connection?
    In VB you can active or inactive your db connections. Try it out it may minimize the frequency of same error.
    Only activate your db connection before update (insert, delete and update) and query/refresh the data.

    What is your strategy to trap the error?
    Are you using ON ERROR GOTO.... statement in your functions/subs?

    Wicky

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •