working with dos prompt

[Jayachandra]

Hi to all,

I have a question. I am running a batch file which has one parameter such as user name. Now I want to pass another parameter such as a password from another batch file. In the first batch file it asks user name - for this I need to pass automatically through VB program. Please help me in this concept.


Thank you all.

[QVeen72]

Hi,

I think u have to use the "Call Function" to run anothr Batch file:

[code=vb]
CALL C:\MyNewBatch.B AT
[/code]

REgards
Veena

[hariharanmca]

Hi,

I think u have to use the "Call Function" to run anothr Batch file:

[code=vb]
CALL C:\MyNewBatch.B AT
[/code]

REgards
Veena

Hi QVeen72, Can you explain where and how can we call it?
To call .bat file i use [CODE=vb]shell("C:\MyNew Batch.BAT")[/CODE]

[QVeen72]

Hi Hari,

He wanted to call one more batch file in a BatchFile.
The Call function has to be written in the Calling or Main BatchFile.


Regards
Veena

[Jayachandra]

Thank you for reply.

Actually I have written a batch file like

sqlldr userid=scott control=x:\abc. ctl log=x:\abc.log

When I run this, it will ask Password. Then immediately I need to pass the password through a password.bat this password.bat may contain password. It should pass to password at command prompt where the first batch file is waiting for password.

Is it possible ? Please reply anybody.

Thank you

[QVeen72]

Hi,

In your .bat you can directly give username/password:

[code=vb]
sqlldr userid=scott/tiger control=x:\abc. ctl log=x:\abc.log
[/code]

If you don't want to hardcode it, or the password keeps changing, then drop and recreate the Batch file with username and password at run time from Front End.

Regards
Veena

[Killer42]

If I read the question correctly, what the OP needs is for the Password.Bat to effectively stack the password into standard input to be picked up by the program which prompts for it.

I don't know how you would go about this.

What about running your VB program first to prompt for the password, then have it generate and execute the batch file with the password included? Of course, you'd probably want to delete the batch file after running it.