Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. scrsadmin

    Oracle stored proc and vbscript access violation

    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...
  2. scrsadmin

    storedProc return values

    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
  3. scrsadmin

    storedProc return values

    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...
  4. scrsadmin

    oracle stored proc and parameter

    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...
  5. scrsadmin

    oracle stored proc and parameter

    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:
  6. scrsadmin

    oracle stored proc and parameter

    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.
  7. scrsadmin

    oracle stored proc and parameter

    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...
  8. scrsadmin

    oracle stored proc and parameter

    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...
  9. scrsadmin

    rights for user to create drop and grant rights

    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...
  10. scrsadmin

    Users are unable to logon to domain

    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...
  11. scrsadmin

    Users are unable to logon to domain

    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?
  12. scrsadmin

    Users are unable to logon to domain

    Yes the second DC is a GC and the Replication is successfull
  13. scrsadmin

    Users are unable to logon to domain

    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.
  14. scrsadmin

    convert from javascript

    So cool. So many Thanks
  15. scrsadmin

    convert from javascript

    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...
  16. scrsadmin

    convert from javascript

    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;
  17. scrsadmin

    simple if cause Object expected

    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"; }
  18. scrsadmin

    javascript operator

    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?
  19. scrsadmin

    javascript operator

    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?
  20. scrsadmin

    javascript operator

    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...

Part and Inventory Search

Back
Top