ODBC Connection

Whilst developing applications on our Intranet server, we occasionally kill all ODBC connections on it (bad code!).  Is there a way to restore  this without re-booting the server.
ff_axelAsked:
Who is Participating?
 
bencampCommented:
You have two routes to take here.  The first one works 80% of the time (depending on your specific problem), and the other one works 99.9% of the time.

From the command line type:
> net stop iisadmin
> net start w3svc

Now, if that returns an error on the first line you need a utility provided on the NT Resource Kit CD (probably
downloadable too), called "kill.exe".  

Then you'll want to type:
> kill inetinfo.exe
> net start w3svc

If you need help locating kill.exe let me know.

0
 
makerpCommented:
when you say kill obdc connections , do you mean individual users connections created in asp

i.e.

con.Open "your_dsn"

getting killed off
0
 
ff_axelAuthor Commented:
No, unfortunately when we lose connections, it applies to all users and all pages on the server.
0
 
makerpCommented:
if your messing with your global.asa then every time you re-save it it will kill all sessions and restart the application . now if you connections are held as sessions you would get what your experiencing.

if the interaction with your asp is dependendent on sessions dont mess with the global.asa on a live site, cos youll keep killing users sessions.
0
 
mberumenCommented:
ff_axel..   Sometimes I experience the same problem. Something goes wrong with the page and the application is unable to process ASP pages.  

I have tried unloading the application from ISM, and I have never been able to make it work. since this application is running on its own separate memory space, my server is fine, but the only way I have been able to restart this application is by rebooting the server.
So Experts...
Just exactly how are you supposed to restart an application gone bad?
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.

All Courses

From novice to tech pro — start learning today.