tnsping

Are you trying to connect to an oracle database through ASP?  I guess I've never heard that term before, but I've been able to connect to oracle through ASP...

2 ways to do it.

1. Use Run method of WSH
Dim oShell
Set oShell = WScript.CreateObject ("WSCript.shell")
oShell.run "cmd /K CD C:\ & Dir"
Set oShell = Nothing

2. Go to www.serverobjects.com and download ASPExec and you can run command line programs with that.

2nd method is advisable

TC,
tnsping is pinging to Oracle db, works the same way as ping

So you can ping the Oracle server to see if it's up?  That's a good idea to do...  :-)

Thanks

Even you can ping the server through a shell command in your program, how are you going to check what the result is?

- Partha

Don't really care about connecting to the db this way, I know I can do it (since I've done it ;)

Today was the first time I've heard about tnsping. I guess its like ping, but it sees if the oracle service is up and running (like jitganguly said).

Don't know how to check the result 'cuz I don't know much about it yet.

Wonder why I don't just try a simple connection, then look at any error code. Hmmmm

did moreorless what jitganguly suggested. Simple query to a small table that I can run on command. Err tells me if db is ok.

if everythings ok then why 'B' ? Remember this is a free service and I spent some time to solver your problem, don't you think you appreciate my help with some good grading

1) I had the idea already about connecting to the db. I didn't need help with that part of it, but I appreciated the code.
2) coulda actually printed the error message.
3) I am the Help Desk. Why would I contact myself? -granted u didn't know that.