Here is a copy of my oracle stored proc that takes 2 inputs and outputs one record. The vbscript is below the stored proc. I am getting an access violation on Set rs = cmdStoredProc.Execute() . I am struggling trying to figure out what the problem is. Has anyone seen this and can guide me on the...
I add this to the do loop and changed the loop to run while num <> 8.
If Not IsNull(cmdStoredProc.Parameters(num)) Then
WScript.Echo cmdStoredProc.Parameters(num)
Else
WScript.Echo "NULL Value"
End if
num = num+1
I have the following oracle stored proc that takes one input and returns 7 values. My vbscript is below the stored proc. When I execute the vbscript it works fine as long as there is no null value in the record that is returned. For example in the database index4 is empty or null. The script...
I know the connection string works as I can run a similar script that only calls an oracle stored procedure without parameters and it works fine. So if I change this script to call a stored proc with out parameters it works fine it only has a problem once I started to add a call to a stored proc...
tsuji,
I tried that and now getting this error.
(32, 1) Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC driver for Oracle][Oracle]ORA-20003:
Can someone help me with this issue. i keep getting argument wrong type, are out of acceptable range, or are in conflict with another. I looked at every sample i could find and can't seem to find what is wrong.
In my orginal code it does have inputTest1 variable. I must have missed it during the copy and pastin to this forum. Here is the code but im still not sure what is wrong!
Dim oCon
Set oCon = WScript.CreateObject("ADODB.Connection")
Dim oRs
inputTest1 = "testtest"
oCon.Open teststrCon
Set...
I am try to call a oracle stored procedure and pass it one parameter. I keep getting an error
argument wrong type, are out of acceptable range, or are in conflict with another.
If anyone can help i would appreciate any help. This is a test of what i need to start off with. I need to be able to...
I have a users that need to be able to create database drop database and grant rights to database. I don't want to give them root userid password but they do need the rights to create database, drop database and grant rights to database.
But i don't want them having rights for other databases...
Titleist I respectfully disagree. The PDC role is for updating accounts. I understand that while the DC that has the PDC role is down you can’t add users or modify them but the design of backup DC is to allow users to continue to authenticate to a DC while another one may be down among other...
The second DC is a DNS server also. And i have tried removing the GC role from the DC2 in question and then add the role back in after the reboot. But still no fix. Should i try to remove the GC from DC1 and then re-add it?
Primary DC (DC1) crashed but DC2 is still up. Users are not able to log onto domain.
What could be the problem? I thought as long as there is a DC up the users would be fine while we work on DC1.
I desperately tried to understand java and I’m still trying. The script was written by some former admin and now I need to modify it. So I thought I would try to get it to work in JavaScript and I also want to convert it to vbs so I can learn about JavaScript and learn more about vbs. But by now...
This is from a javascript that i am trying to convert to vbscript.
How can i do the 6 lines below in VBscript?
dnRE = /dn: \w, \w/i;
cnRE = /^cn: (.*), (.*)/;
givenRE = /^givenname: (.*)/;
snRE = /^sn: (.*)/;
mailRE = /^mail: (\S+)/;
testRE = /@test\.nc\.gov/i;
What is wrong with this code? I keep getting
Microsoft JScript runtime error: Object expected for the line that has the if statement
icrosoft JScript runtime error: Object expected
var test = "3";
If (test == "3")
{
test = "2";
}
does the givenRE = /^givenname: (.*)/;
mean to match givename: space and any character except newline?
and then does cnRE = /^cn: (.*), (.*)/;
mean to match cn: space any character except newline comma space any character except newline?
Okay so then what does this do
cnRE = /^cn: (.*), (.*)/;
givenRE = /^givenname: (.*)/;
If i understand this right the value cn: with a space is what is will be matched against. But then what is the
(.*), (.*)
do?
I normall write in VBscript but i was given a javascript and asked to fix a problem with the output. As i am reading through the script i don't understand som of the syntax.
Can someone tell me what does these do? I understand that it is assgining something to the variables but i done't...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.