Re: How to revalidate the connection (VB ADO) after database reboot

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

aali wrote:
Hello All
I am trying to solve a scenario where, when database got rebooted we
do not have to reboot the application servers. In my case I have
oracle database running on its own physical box and application
server running VB code.
Is there a way we can avoid rebooting the app. server following
database reboot?

Frankly, I'm puzzled that you would think you need to reboot the app server
simply to re-establish database connections. Please explain your reasoning.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Is 5.0.7 ready for production?
    ... >> the database is started. ... Spent six hours on that server last night and this morning. ... does kick in and reboot the server if I wait. ... Progress to start up, but if a wait a while the machine locks instantly ...
    (comp.unix.sco.misc)
  • Re: Access Databases & IIS 6.0
    ... PID to Application Pool." ... You don't need to reboot the server. ... I administer a Windows Server 2003 running IIS 6. ... Unable to establish connection to database. ...
    (microsoft.public.inetserver.iis.security)
  • Re: I have a database on a network drive that I use for archiving purposes, but when the server is r
    ... server service and the startup parameters of the instance. ... cases the database always come up suspect after a reboot. ...
    (comp.databases.ms-sqlserver)
  • Re: system reboot
    ... Active Directory is essentially a database, and like most databases, it has index and journaling for recovery in the event of an unexpected shutdown. ... So keep an eye on your event logs to look for corruption...and you should determine *why* the server rebooted on its own. ... Even if windows chose to reboot, it would've cleaned up after itself, so it sounds as though the problem is in a lower layer than the OS. ...
    (microsoft.public.windows.server.sbs)
  • Re: Could not find stored procedure problem
    ... No change of server or version and the database was created on the ... machine that I have the problem on, other procedures that query the same ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)