sqlplus password problem

[battaman]

I am currently working on an application that makes use of the thesaurus capability in Oracle8i. I use the following code in VB to automate the process of of dropping a thesaurus by running a short script:

strCommand = "sqlplus ctxsys/" & pword & " ""@" & App.Path & "\dropThes.sql"""
ProcessId = Shell(strCommand, vbHide)

where pword is provide by the user in the app. This works perfectly when the correct password is entered, but problems arise when an incorrect password is entered. When an incorrect password is entered sqlplus prompts for a username and password to attempt to login again. This is bad for e, because I'm trying to automate this process and the prompt for a username and password causes my app to hang. Is there any way to get around this (i.e. another way to drop a thesaurus or some way to let my vb app know that the password was incorrect)? Is it possible to check if the password is correct before running the shell command?

Thanks

 

[faheemrao]

Ok

I think you want to run this scripts without using SQLPlus refering your other post.

Now my first question would be that why you are not using the ODBC to deal with Oralce database.

I know there are methods in VB that can Execute SQL copmmands directly and if that SQL fails you can catch the Exception and do appropriate action.