Passing parameter in Batch File through VB6

November 23, 2009 at 22:23:08
Specs: Windows XP
Can u help me out pls.
I need to pass the parameter in batch file which contain on SQL file.

my.sql file has :
conn system/orcl1012#@orcl10
create user &user identified by &pwd;
grant dba to &user;

and in batch file
sqlplus /nolog @c:\my.sql %1 %2

and in the form code:
host ("c:\batch.bat" + "surabhi" + " " + "acharya" + "")

its giving error.


See More: Passing parameter in Batch File through VB6

Report •

#1
March 19, 2010 at 04:50:17
The first step is to make some simple declarations. Add the
following code to your projects declarations.

Private Const VER_PLATFORM_WIN32s = 0
Private Const VER_PLATFORM_WIN32_WINDOWS = 1
Private Const VER_PLATFORM_WIN32_NT As Long = 2

Private Declare Function GetVersionEx Lib "kernel32" Alias
"GetVersionExA" (lpVersionInformation As Any) As Long

Private Type OSVERSIONINFO
OSVSize As Long
dwVerMajor As Long
dwVerMinor As Long
dwBuildNumber As Long
PlatformID As Long
szCSDVersion As String * 128
End Type



Report •
Related Solutions


Ask Question