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 wOOdy-Soft 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: *

  • Users: scrsadmin
  • Content: Threads
  • Order by date
  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 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...
  3. 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...
  4. 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...
  5. 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.
  6. 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;
  7. 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"; }
  8. 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...
  9. scrsadmin

    seperate out name

    I have to build a way to seperate out First name middle name and last name in a txt file. This comes in as a csv that looks like this; firstname middlename lastname, emailaddress, userid What i need is to be able to serapte out each part of the name. I tried using array but not all names have...
  10. scrsadmin

    Address List based on OU

    We are in need of a address list in exchange based on contacts that are in a specfic OU. We have many external contacts and create OUs for each different company. For example all statefarm external contacts would be in a OU called statefarm and then we would have another OU called allstate and...
  11. scrsadmin

    pros and cons for DC and File print server at remote site

    Can someone point me to or give me some pros and cons for having a Domain Controller (windows 2003) and File and print server at a remote site? My boss does not want to have any servers at our satellite sites, but I think we should. He has asked me to give him pros and cons on having Domain...
  12. scrsadmin

    Oracle 10g OEM

    I installed oracle 10g Enterprise Manager on my vista desktop and i notice that the instance state (shutdown, startup, mounted, open) is grayed out so as i can't select any of them. Is there something i need to do to have the 10G oem work with th 9i database?
  13. scrsadmin

    advise for database acceses 24/7

    What if any reasons are there to shutdown the production database? I have advised my manager that i would like to backup our database offline once a week. He asked why couldn't we leave it up forever and just do online/hot backups. I could use some advise here from all of you! Reasons to...
  14. scrsadmin

    keeping print servers in sync

    I have two print servers that will be used by an application to send files to print. It will be sending files to either of two print servers with 200 printers. I need to keep the printer drivers and configuration, like what tray to print letter head from and so on. How can I keep them in sync...
  15. scrsadmin

    Whats wrong with the if

    Heres is my code. It says Syntax error at line 44 : `fi' is not expected. Why? #------------------------------- # Put file to imaging ftp server. #------------------------------- { rrfile=/tmp/tf2tiff export prod_a=tf2tiff-vm export prod_b=btf2tiff-vm TIPFUP=$( /usr/sbin/ping $prod_a -n...
  16. scrsadmin

    newbie at sql. Need select for only numeric values in a column

    I need to do a select against iadocument where maindex1 is only 9 digits. It has to be only 9 and can only be digits no alphabet. I don’t want it to return a row if the data has more or less then 9 digits and it has to be only numeric in value.
  17. scrsadmin

    round robin query

    I need to write a script that will send data to two different servers in a round robin style. I’m not sure what method I should take and wanted some other opions. I could write it so that it queries a file that will either have a 1 or a 0 string in it. And if it has a 1 then send the data to...
  18. scrsadmin

    long running query

    I'm trying to search for subfolders that start with the letter R in a C:\Program Files\iafolder\TempFiles and then delete only the one found. I created this but it seems to run long. It finds three, deletes three and then i get an hour glass for about 5 more minutes before it goes to the next...
  19. scrsadmin

    delete files but not all in a folder

    I need help with some logic or more. My code is suppose to delete files in a folder if they are older then 7 days and they are not a file listed in files_keep.txt. I need it to read through the files_keep.txt file and insure its not in there before it deletes the file. I don't want to read...
  20. scrsadmin

    printing tif files

    Need help scripting to print tif files. I will ahve a list of 100 files that i want to automate the print. But not sure how to script printing a tif file.

Part and Inventory Search

Back
Top