ODBC query in PWS -vs- IIS 5.1

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ VBscripts
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - LDAP connection question... I have a number of wireless machines that reside as stand-alone devices (i.e. not part of the domain). After they are started, the user logs into the machine locally, then gains wireless access. I then want to run a script to map drives and printers based on the group membership of a domain username and password they provide. This is a sort of post-facto login script. I can't figure out how to query the LDAP from the outside of the domain to determine group memberships however. Any suggestions? Portion of the script that works from domain member machine...: ' Now determine the memberships of the presented user... targetO = "LDAP://CN=" + strUser + ", " + mydomain WScript.Echo "Your fully qualified domain name is: " & targetO & VbCrLf Set oUser = GetObject(targetO) Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159557
  - 2
    - Event Log - Office XP Hello, Here is a snippet from my code. It grabs all events that meet a certain criteria LogFile = 'Application' EventCode = '11707' This works fine. It grabs all the new software installations. I want to narrow this down to Office XP. The Message I want to grab is 'Product: Microsoft Office XP Professional -- Installation operation completed successfully.' I tried to add this msgCheck = "Product: Microsoft Office XP Professional -- Installation operation completed successfully." <<< code >>> if msgCheck = objEvent.Message then <<< do something >>> It doesn't work. I also tried "Select * from Win32_ntllogEvent where Message = msgCheck" in an ExecQuery Any ideas? Thanks in advance Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159556
  - 3
    - multiple instances of ms agent from a web page ? i would like to get multiple ms agent characters talking on the screen at once, but for some reason my code isn't working... any good examples or feedback on my code welcome... also how do i get separate onclick events for the separate instances? thanks... <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <TITLE>Try out Microsoft Agent</TITLE> <META http-equiv=Content-Type content="text/html; charset=windows-1252"> <OBJECT id=Agent style="LEFT: 0px; TOP: 0px" codeBase=#VERSION=2,0,0,0 classid="clsid:D45FD31B-5C6E-11D1-9EC1-00C04FD7081F"></OBJECT> <OBJECT id=TruVoice codeBase=#VERSION=6,0,0,0 classid=clsid:B8F2846E-CE36-11D0-AC83-00C04FD97575></OBJECT> <SCRIPT language="VBScript"> Dim Peedy1 Dim Peedy2 Dim LoadRequestUNC Dim LoadRequestURL Dim GetShowAnimation Sub Window_OnLoad ' Load the character LoadCharacter End Sub Sub InitCommands ' Give user access to the Advanced Character Options dialog Peedy1.Commands.RemoveAll Peedy2.Commands.RemoveAll Peedy1.Commands.Add "ACO", "Advanced Character Options" Peedy2.Commands.Add "ACO", "Advanced Character Options" End Sub Sub Monologue ' Start the monologue Peedy1.Speak "Hey!" Peedy1.Play "Blink" Peedy2.Speak "reminder: feed the dog" Peedy2.Play "RestPose" Peedy1.Speak "reminder: feed the cat" Peedy1.Play "Pleased" Peedy2.Speak "reminder: feed the monkey" Peedy2.Play "Explain" Peedy1.Speak "reminder: feed the cow" Peedy1.Play "Blink" Peedy2.Speak "reminder: feed the lizard" Peedy2.Play "Explain" Peedy1.Speak "reminder: feed the goat" Peedy1.Play "Blink" Peedy2.Speak "reminder: feed the capybara" Peedy2.Play "Think" Peedy1.play "Blink" Peedy2.Play "Explain" Peedy1.Play "GestureRight" Peedy2.Play "Think" Peedy1.Speak "reminder: feed the hamster" Peedy1.Play "RestPose" End Sub Sub DoIntro InitCommands ' Set the character's language ID Peedy1.LanguageID = &H0409 Peedy2.LanguageID = &H0409 ' Make the character appear On Error Resume Next Peedy1.MoveTo window.event.screenX-window.event.clientX+400,window.event.screenY-window.event.clientY+50 Peedy1.Show Peedy2.MoveTo window.event.screenX-window.event.clientX+300,window.event.screenY-window.event.clientY+150 Peedy2.Show Monologue() End Sub Sub Agent_RequestComplete(ByVal Request) ' The Request to load the ACF character fails If Request = LoadRequestURL Then ' If it failed If Request.Status = 1 Then 'Msgbox "Peedy could not be loaded. The server may be busy. Try refreshing this page." Msgbox "Merlin could not be loaded. The server may be busy. Try refreshing this page." Exit Sub ' If it succeeded ElseIf Request.Status = 0 Then ' Assign Peedy to the loaded character 'Set Peedy = Agent.Characters("Peedy") Set Peedy1 = Agent.Characters("Merlin") 'Set Peedy2 = Agent.Characters("Merlin") Set Peedy2 = Agent.Characters("Peedy") ' Get the preliminary animations necessary to show Peedy Set GetShowAnimation = Peedy1.Get ("state", "showing, speaking") Set GetShowAnimation = Peedy2.Get ("state", "showing, speaking") Peedy1.Get "animation", "Blink, Greet, Pleased, Explain, Think, GestureRight,Idle1_1,Idle2_2, Announce, Uncertain", False Peedy2.Get "animation", "Blink, Greet, Pleased, Explain, Think, GestureRight,Idle1_1,Idle2_2, Announce, Uncertain", False End If ' The request to get the animation ElseIf Request = GetShowAnimation Then ' If it failed If Request.Status = 1 Then Msgbox "Request to load the Show animation failed. The server may be busy." Exit Sub ' If it succeeded ElseIf Request.Status = 0 Then DoIntro End If End If End Sub Sub LoadCharacter On Error Resume Next ' Attempt to load the character from the Microsoft Agent Chars directory Set LoadRequestUNC = Agent.Characters.Load ("Merlin", "Merlin.acs") ' If it fails... If LoadRequestUNC.Status <> 0 Then ' Attempt to load the character from the Microsoft Agent site Set LoadRequestURL = Agent.Characters.Load ("Merlin", "http://agent.microsoft.com/agent2/chars/merlin/merlin.acf") ' It didn't fail so assign Peedy to loaded character file Else ' Assign Peedy to the loaded character Set Peedy1 = Agent.Characters("Merlin") DoIntro End If ' Attempt to load the character from the Microsoft Agent Chars directory ' Set LoadRequestUNC = Agent.Characters.Load ("Peedy", "Peedy.acs") ' If it fails... If LoadRequestUNC.Status <> 0 Then ' Attempt to load the character from the Microsoft Agent site Set LoadRequestURL = Agent.Characters.Load ("Merlin", "http://agent.microsoft.com/agent2/chars/merlin/merlin.acf") ' It didn't fail so assign Peedy to loaded character file Else ' Assign Peedy to the loaded character Set Peedy2 = Agent.Characters("Peedy") DoIntro End If End Sub Sub Agent_Click (ByVal CharacterID, ByVal Button, ByVal Shift, ByVal X, ByVal Y) Peedy1.Stop Peedy1.Play "Alert" Peedy1.Speak "\pit=170\drop the chalupa!!" Peedy2.Play "Blink" Peedy2.Speak "\pit=220\no!!" End Sub Sub Agent_DragComplete (ByVal CharacterID, ByVal Button, ByVal Shift, ByVal X, ByVal Y) Peedy1.Stop Peedy1.Play "Blink" Peedy1.Speak "could i interest you in a \emp\mortgage?! " Peedy2.Speak "yes! \emp\definitely!" Peedy2.Play "Blink" End Sub Sub Agent_Command (ByVal UserInput) If UserInput.Name = "ACO" Then Agent.PropertySheet.Visible = True End If End Sub </SCRIPT> </HEAD> <BODY bgColor="white"> <P align="center"> <STRONG>Note:</STRONG> this page requires the "Microsoft Agent" Active-X plug in and probably IE 5.5. If you don't see <STRONG>and</STRONG> hear a little man talking, go to <A href="http://www.microsoft.com/msagent" target="_new">www.microsoft.com/msagent</A> and install the MS Agent. </P> </BODY> </HTML> Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159551
  - 4
    - Ignoring Javasript Errors wtih InternetExplorer Hi, I have a VB script which uses the InternetExplorer object to download data from a website. Unfortunately everytime a Javascript error occurs (these happen randomly and the website is not owned by me so there's nothing I can do about it) it pauses and I need to click Cancel in the popup box which appears. How do I get my script to ignore/bypass these errors? Thanks, Anon. Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159547
  - 5
    - Synchronization Scripting Is there a script a synchronization as if you are offline, the offline files icon is located in the Start menu bar and you right click on the icon and select Synchronize? I found a script that will launch mobsync.exe but there has to be a shorter way of doing the same thing. Any help would be appreciated. SDA Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159543
  - 6
    - Right-Click Block Does anyone know code that I could write in vbscript or jscript that would block a right-click menu from coming up on a web page? i.e. if a person right-clicks the mouse button, no menu appears. An example of this is on: http://www.stephenfuller.com/frms_home.html Thanks. Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159541
  - 7
    - Refresh Security Context I'm trying to figure out a way to Add and Remove a User to the Administrator Group via. a VB Script. Aside from phsyically adding them to the group from a script (which I know how to do) I was wondering if there was a way to reload or refresh their security rights under windows XP WITHOUT having to log out or log back into the machine? If I do Have to Log out and Back in to refresh, is there a way to do that scriptably? Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159537
  - 8
    - Reading Environment Variable I need to read the UserDomain environment variable from within a VBScript. Any ideas how would I do about it? Also, Is it in the registry somewhere? Thank you. Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159536
  - 9
    - regular expression help Hi all, I am trying to find a regular expression that does the following:- Sample Strings: 1. "/somefolder" 2. "/specific_folder/aaaa" 3. "/myfolder/bbbb" I would like to match everything after the first "/" for all strings except #2. i.e. for all cases except when it starts with "specific_folder". Any ideas? Right now what I have for my regular expression is "/(.*)". But that captures everything. TIA! Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159534
  - 10
    - Create users in AD I have looked on the Microsoft Scripting page and found a sample script to create local users - but not one to create users in AD. I need a script to create users in the "User" container, enable the users, set the password to "password". All suggestions will be greatly appreciated. TIA, Bill Burke bill@2burkes.com Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159532
  - 11
    - Machine translation module Hi everybody, I want to incorporate a machine translation module in my ASP pages to translate the Chinese into English. Is there any plug-in I can buy to do it? Thanks BC Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159531
  - 12
    - Asp - How Do i print after I validate a form I have an ASP form that I use validation code on. I am a newbie at ASP and I am not very familiar with VB Script. I want to print the form after it has been validated as part of the vb code. But I do not want to have the form print unless it is validated. Any ideas on how to do this? I did add a simple javascript command to print. But it prints whether the form is validated or not. Thanks for any help, Ryan Nielsen Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159528
  - 13
    - Call vbScript SubRoutine with OnClick Is there a way of calling a vbScript Sub Routine using OnClick? I have a very complex error checking routine and I am not familiar enough with Java Script like I am with vbScript. I have worked with this for over 12 hours and I am stuck! <Input Type="Button" Value="Record Vote" Name="V1" OnClick=<%"Call AddVotes()"%>> <%Sub AddVotes() Response.Write "Add Votes Called" End Sub%> Can this be done? If it can what am I doing Wrong Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159524
  - 14
    - Het zal toch niet zijn wie ik denk dat het is? Is het die Ear Youth weer? Nee, het is Arjen Jongeling! Het is een kwestie van geduld voor heel usenet Hollands lult Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159518
  - 15
    - GetFile Problem with network drives I'm running into the following problem and I was hoping someone can help. I have the following code snipet in a script I'm running from a DOS prompt. ---------------------------------- qDriveFileName = "\\cgshare\share1\version.dat" Set filesys = CreateObject("Scripting.FileSystemObject") if filesys.FileExists(qDriveFileName) then 'Get a reference to the file Set qDriveFile = filesys.GetFile(qDriveFileName) if Err.Number <> 0 then MsgBox "Error: " & Err.Number & ", " & Err.Description wscript.quit else qDriveDate = qDriveFile.DateLastModified end if end if --------------------------------- the FileExists returns true but the getFile give me error 53, File Not Found. Anybody know what's going on here? I tried searching through Google but couldn't find a solution. This code seems to work fine when I'm dealing with local drives. -- Mark Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159517
  - 16
    - problems with activex object taking the top focus when creating a Hi, I`m trying to develop a menu system for one of my apps, the problem lies in the fact that there is a graphing activex control on every page. Normally I would just create a menu using divs. But the activex object always takes the top focus and the index-z properties have no effect. After a bit of looking around I found that it's not possible to change the properties of an object in that way. So I thought I could use window.createpopup to create multi windows for the menus. So far though I can only seem to keep one window on the screen at once. Again after some reading it seems that once you move away from the popup the popup disappears automatically. I`m trying to write a heriachal menu system where the previous options stays as you navigate across, (the same as the microsoft menu system). Anybody else having / had this problem or know of a way around this? I`m using vbscript for the client side of things. thanks. Scot. Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159515
  - 17
    - problems with activex object taking the top focus when creating a Hi, I`m trying to develop a menu system for one of my apps, the problem lies in the fact that there is a graphing activex control on every page. Normally I would just create a menu using divs. But the activex object always takes the top focus and the index-z properties have no effect. After a bit of looking around I found that it's not possible to change the properties of an object in that way. So I thought I could use window.createpopup to create multi windows for the menus. So far though I can only seem to keep one window on the screen at once. Again after some reading it seems that once you move away from the popup the popup disappears automatically. I`m trying to write a heriachal menu system where the previous options stays as you navigate across, (the same as the microsoft menu system). Anybody else having / had this problem or know of a way around this? I`m using vbscript for the client side of things. thanks. Scot. Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159514
  - 18
    - Capital Letters or Uppercase Letters I was using this script four four years and it worked until I changed my Page. <TD Width="3%"><Span Style="Text-Transform: Uppercase"><INPUT TYPE="Text" Name="txtPosA" Size="2" MaxLength="2"></Span> Does anyone know what change was made for why this script no longer works? Tnanks in Advance Bill Barber Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159512
  - 19
    - VBScript & Windows Media Services? Is it possible to start a Windows Media Services publishing point using VBScript? I found the following Visual Basic .NET code example which will start a publishing point, but I've been unsuccessful in converting it to vbscript. ------ Imports Microsoft.WindowsMediaServices.Interop Imports System.Runtime.InteropServices ' Declare variables. Dim Server As WMSServer Dim BCPubPoint As IWMSBroadcastPublishingPoint Try ' Create the WMSServer object. Server = New WMSServer() ' Retrieve a broadcast publishing point. BCPubPoint = Server.PublishingPoints.item ("Test") ' Enable the archiving plug-in. BCPubPoint.BroadcastDataSinks.Item("WMS Archive Data Writer").Enabled = True ' Initialize the publishing point and start broadcasting. BCPubPoint.Start() ' Start archiving the broadcast data locally for rebroadcast. BCPubPoint.StartArchive() Catch errCom As COMException ' TODO: Handle COM exceptions. Catch err As Exception ' TODO: Exception handler goes here. Finally ' TODO: Clean-up code goes here. End Try --------- TIA, Joseph Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159504
  - 20
    - VBScript & Windows Media Services? Is it possible to start a Windows Media Services publishing point using VBScript? I found the following Visual Basic .NET code example which will start a publishing point, but I've been unsuccessful in converting it to vbscript. ------ Imports Microsoft.WindowsMediaServices.Interop Imports System.Runtime.InteropServices ' Declare variables. Dim Server As WMSServer Dim BCPubPoint As IWMSBroadcastPublishingPoint Try ' Create the WMSServer object. Server = New WMSServer() ' Retrieve a broadcast publishing point. BCPubPoint = Server.PublishingPoints.item ("Test") ' Enable the archiving plug-in. BCPubPoint.BroadcastDataSinks.Item("WMS Archive Data Writer").Enabled = True ' Initialize the publishing point and start broadcasting. BCPubPoint.Start() ' Start archiving the broadcast data locally for rebroadcast. BCPubPoint.StartArchive() Catch errCom As COMException ' TODO: Handle COM exceptions. Catch err As Exception ' TODO: Exception handler goes here. Finally ' TODO: Clean-up code goes here. End Try --------- TIA, Joseph Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159503
  - 21
    - Getting version of Microsoft.XMLHTTP object prior to ADOB.Stream? I'm _totally_ new at creating ADOB.Stream objects, etc. - and I've been able to succesfully implement the code that Tom Lavedas supplied to me. However, my question is this: I also want to utilize this code to download the McAfee program, and I need it to check the remote exe contained in the url for it's current version. If the version on the server is newer than what I have in my folder, then I want it to go ahead and download it. I've had no luck in finding any information on how to pull the XMLHTTP object version. Anyone have any ideas and know what the correct properties/methods are to get such information? Rob Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159502
  - 22
    - Commas in the CN name I am using scripts to create user logins in AD with Windows 2003 domain controllers. When I try to create a user with the CN name being something like "Blow, Joe" my script chokes. I can create a login with a CN name of "Blow Joe", with a space, but not a comma. I get the rror message "Active Directory: An invalid Active Directory pathname was passed." Same problem when I try to read a specific CN that has a comma in it with a script. The script chokes. However, if you create a login using the utility Active Directory Users and Computers, by default the CN name is created in the form of "Blow, Joe." Also you can go in on the gui and manually change the CN name to contain a comma. Any suggestions on how to create a CN name with scripting? Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159500
  - 23
    - Need to Display Heights of Individuals Corrcetly I Can Enter the Heights of Individuals Correctly and it goes into Databases Correctly. Examples 5'11", 5'9" and VWXYZ. When I go to Display them on the Page for the school district police department they display as: 5'1, 5'9 and VWXYZ. Does Anyone know why is the Double Quote " Will Not display? Thanks in Advance Bill Barber Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159499
  - 24
    - newbie:arays in active x scripts We are trying to import a binary file to a database table based on logic.To do so, I am using stream functions and read the data into an array .How do I read the array containing byte data .Here is an part of the script : Dim CDTable Dim s Dim Buffer Dim version Dim FileName Function Main() fname="C:\Documents and Settings\Pooja\Desktop\ConvergentGDRQ_05011200.CDR" Set s = CreateObject("ADODB.Stream") Const adTypeBinary = 1 'Open up the table for reading s.Open s.Type = adTypeBinary s.LoadFromFile (fname) 'Determine the version Buffer=s.Read(4) 'This part gives me error "type mismatch ' . It does not accept Buffer(0) or anything. If (buffer(0) = CByte(0) And buffer(1) = CByte(3) And buffer(2) = CByte(0) And buffer(3) = CByte(0)) Then version = 1 Else version =0 End If Main = DTSTaskExecResult_Success End Function Thanks, Pooja Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159495
  - 25
    - PSEXEC fails when doing a NetStat inside a vbscript I am trying to run a netstat using psexec and wsh's WScript.Shell. I keep getting the following error: netstat.exe exited on ServerName with error code 1. If I run the exact psexec command from the command line on my machine(against another machine) it works just fine, but as soon as I embed the whole thing in vbscript I get the error above. Below is a summary of what I am doing. Any help would be greatly appreciated!!! Thanks. Mike command_exec = "psexec.exe" cmdNetStat = "-s netstat.exe -a " & Chr(124) & " find " & Chr(47) & "C " & Chr(34) & ":33569" & Chr(34) Set objStdOut = WScript.StdOut If WScript.Arguments.Count > 0 Then strComputer = WScript.Arguments.Item(0) Else strComputer = "." End If strPath = command_exec & " " & "\\" & strComputer & " " & cmdNetStat Set objWshShell = CreateObject("WScript.Shell") Set objExec = objWshShell.Exec (strPath) Set objStdOut = objExec.StdOut strResult = objStdOut.ReadAll WScript.Echo strResult Set objExec = Nothing Set objWshShell = Nothing Set objStdOut = Nothing Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159493
- Next
  - 1
    - Killing a Shelled Oracle SQLPlus Process I have a VBS script running as a scheduled task once a minute on a Win2K server which connects to a database (populated from an intranet site) and checks for new jobs to run in Oracle SQLPlus. My job table looks like this: JOB PROCESSED SUBMITTED_BY ============================================= interface1.sql Y user1 interface1.sql Y user2 interface2.sql Y user2 interface1.sql N user1 The idea is that if an outstanding job is found (PROCESSED = N) then the script processes it by running the following function and passing the name of the JOB (SQL file) to it. Function processRequest(jobName) Dim wshShell On Error Resume Next Set wshShell = WScript.CreateObject("WScript.Shell") wshShell.Run "SQLPLUS user/password@database @" & _ jobName, 0, True Set wshShell = Nothing If err.number = 0 Then processRequest = True Else processRequest = False End If On Error Goto 0 End Function After the job is processed (usually 2 or 3 seconds) the job is flagged as process and the user is sent an email. This all works fine. HOWEVER! The problem I have with it, is that if I pass it a Job that doesn't exist or is full of crap (for testing) I get two process that sit there doing nothing (WScript and SQLPLUS.EXE) and the whole script stops. The WScript process gets killed after 1 minute by the task scheduler automatically, but the SQLPLUS.EXE process never gets killed unless I go in and kill it manually. I am therefore trying to find a way to avoid this so that the script can manage itself. Does anyone have any suggestions on how this could be done? Or is there anyway I can monitor SQLPlus to see if its stopped, or force it to close? TIA, Colin Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159488
  - 2
    - How to automate data input to Word template with VBScript Can someone tell me how to use VBScript to populate a word document with data automatically? Im putting a legal template together with a bunch of contract stipulations and I'd like to be able to popup a window and have each item be able to be checked by the user, then all items with a check mark are sent to a new legal template and populated in the appropriate sections of the template using Word bookmarks. I've sucessfully used the Doc.Bookmark object to get data from the user via Input boxes and populate a Word template, but popping up windows with each contract item and asking the user yes/no if they want to include it would be messy. Any help would be most appreciated, thanks in advance! Randy randy-george@comcast.net Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159481
  - 3
    - database access error I am trying to access database from VBScript, just want to append a record I have setup my dsn TC to point to taget database (\\...\....mdb). I used following code and it says "Error, obejct requrited" table name is "TC_Area" and field names are "TC_Area_Number", and "Area Name" Set conn = Server.CreateObject("ADODB.Connection") 'conn.Open "DSN=TC;uid=;pwd=" SQLStmt = "INSERT INTO TC_Area (TC_Area_Numbe, Area Name)VALUES('02','My test')" Set RS = conn.Execute (SQLStmt) set rs = nothing conn.Close set conn=nothing Thanks Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159476
  - 4
    - Problem reading a DWORD key in XP I am trying to retrieve the current value of the ExplorerFlags entry, which is either 16 or 34 in decimal. But the result I get with the code below is always 0! Any help would be much appreciated. TIA Phil KeyToRead = "HKCR" SubKey = "\Folder\shell\open\ExplorerFlags" WshShell.PopUp KeyToRead & SubKey ' = HKCR\Folder\shell\open\ExplorerFlags ValueToRead = WshShell.RegRead(KeyToRead & SubKey) WshShell.PopUp ValueToRead ' return 0 instead of either 16 or 34 Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159474
  - 5
    - VBScript how to call different pages I'm writing a VBScript - all is going good, but it is getting extremely long. I would like to know how I can "break up" some of this code. There are some parts of it that I would like to put in a different page. ---page1.vbs dim intCNT intCNT = 6 call page2.vbs (pass variable intCNT to page2.vbs) handle returned value from page2.vbs ---page2.vbs MsgBox "hi - I'm here on page2.vbs" & intCNT intCNT = 15 return back to page1.vbs (return "new" value of intCNT) Can anyone show me what I will need to do to accomplish this? Thanks in advance... Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159470
  - 6
    - Help! How do i make this wav file play until stopped? I have this script which makes a wav file play whenever somethign is printed. Now I need it play that wav file over and over until someone presses "OK" or hits stop or something. Can anyone modify my code so that happens? Please help thanks. Here is my script: ***************************** Option Explicit Dim strComputer, strTargetPrinter, strWaveFile, i, j, LoopVariable Dim objWMIService, objPrintQueue, colPrintQueues, objShell Const PAUSETIME = 500 strTargetPrinter = "LABSTAT" strWaveFile = "c:\statlabelsoundscript\buzzer.wav" LoopVariable = 1 Do Until LoopVariable = 0 strComputer = "LABDESK" Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colPrintQueues = objWMIService.ExecQuery _ ("Select * from Win32_PerfFormattedData_Spooler_PrintQueue Where Name = '" & strTargetPrinter & "'") For Each objPrintQueue in colPrintQueues If objPrintQueue.Jobs <> "0" Then Set objShell = CreateObject("Wscript.Shell") objShell.Run "sndrec32 /play /close """ & strWaveFile & """",0,True Set objShell = Nothing Wscript.Echo "Name: " & objPrintQueue.Name Wscript.Echo "Current jobs: " & objPrintQueue.Jobs End if NEXT Wscript.Sleep PAUSETIME LOOP ********************************************8 Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159469
  - 7
    - "Potential Scripting Violation" pop-ups for Dig. Certificates Hi I am trying to write a script, that would involve issuing certs. Whenever a cert is issued a 2 windows pop-ups entitled "Potential Scripting Violation" always appear. I am wondering if the title of this box suggest it impossible to script issuing certificates, or whether it is possible through act to somehow sendkeys to select yes on these dialogs. Thank You Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159468
  - 8
    - Arjen Jongeling, een oude bekende Hoewel, Arjen Jongeling is hier nog nooit geweest en ik denk dat Arjen Jongeling hier ook nooit meer zal terugkomen. Sterker nog, Arjen Jongeling zit hier helemaal fout. Maar ja, het doet het goed in de Google archieven. Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159467
  - 9
    - AllUsersStartup in Windows 98 I'm writing a script that lists all programs in the Startup folders in any Windows version in any language. With the SpecialFolders collection, this is relatively easy to do, with _one_ exception -- AllUsersStartup under Windows 98. For W98, SpecialFolders("AllUsersStartup") returns an empty string, but in the U.S. version of W98, any shortcut in %WINDIR%\All Users\Start Menu\Programs\Startup _will_ launch when W98 starts up. Since the spelling of "All Users\Start Menu\Programs\Startup" is language-dependent, is there any way to find the location of shortcuts in this folder via VBS in W98? regards, Andy -- ********** Please send e-mail to: usenet (dot) post (at) aaronoff (dot) com ********** Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159465
  - 10
    - How to convert from ColdFusion? I have taken over an application conversion from Cold Fusion to ASP and this involves some LDAP work ... I'm trying to determine how to make these conversions from Cold Fusion <cfldap action="QUERY" name="getDN" attributes="cn,dn,givenname,sn,telephonenumber,orgpersonmanagersname, manager" start="ou=employees, o=ACME" scope="SUBTREE" filter="(&(objectclass=*)(uid=#username#))" server="directory.acme.com" secure ="cfssl_basic" port = "636"> <cfset mgrname = listfirst("#getDN.orgpersonmanagersname#")> <cfset mgrname = removechars(mgrname, 1, 4)> <cfldap action="QUERY" name="getmgr" attributes="cn,dn,givenname,sn,telephonenumber, uid" start="ou=employees, o=ACME" scope="SUBTREE" filter="(&(objectclass=*)(uid=#mgrname#))" server="directory.acme.com" secure ="cfssl_basic" port = "636"> I was told ADSI was the way to go. But everything I've tried has been unsuccessful. Any pointer, insights, help would be most appreciated. BBB Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159463
  - 11
    - WMI + StdRegProv + REG_MULTI_SZ = no worky I can't figure out why this isn't working (code below). Do I need to enum the keys values first and get the data from the enumerated array or does it just not work? I have other scripts like this that work fine only they get other value types (REG_SZ, REG_DWORD, etc.). I've done test runs on a few PCs, a few keys, and a few REMOTEs all with the same result (result below code). '---Start Code--- Const HKLM = &H80000002 'HKEY_LOCAL_MACHINE strComputer = "REMOTE" 'Get OemDuplicatorString '========== Set oRegistry = GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & _ strComputer & "\root\default:StdRegProv") sBaseKey = "SYSTEM\Setup\" sValueName = "OEMDuplicatorString" oRegistry.GetMultiStringValue HKLM, sBaseKey, sValueName, sValue Wscript.Echo "OEMDuplicatorString: " & sValue '---End Code--- '---Start Result--- Line: 11 Char: 4 Error: Type mismatch Code: 800A000D Source: Microsoft VBScript runtime error '---End Result--- Any help is appreciated. UNoHu Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159458
  - 12
    - connected PC's/logged in users Hi all, Is it possible using vbscript to either list all logged on users on a domain, OR get all connected PC's to a domain (W2K) - like when you open up Network PLaces on your PC I've already tried solutions involving LanManServer (for the users) or listing all machines in a domain - I specifically need either all logged on users or all connected machines (this is in order that net sends (for an intranet messaging app) won't have to timeout when a user/machine can't be found on the network - this is important when sending out ~200 messages!) Any help would be gratefully appreciated - have been scouting the groups for a while with no success. TIA, rois. Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159457
  - 13
    - New To Scripting - running script based on username Hi, I am new to scripting, and trying to find some code or the right syntax. Just trying to create a script that would check the name of the user logging on, and based on their username, goto or execute a different part of the script. Basically, if any part of the username has TEMP. Then the script should goto a different step etc.. I hope this makes sense? Tomi Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159455
  - 14
    - implicit type coercion hi there: simple question : Whey is that when a=5 b="10" c=a+b msgbox typename(c) returns double but with a=5 b=10 c=a+b msgbox typename(c) returns integer thanks Biju Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159454
  - 15
    - get ip adress How can i catch the ip adress with vbscript and use it to map my network drives ? Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159453
  - 16
    - Remove Volume control icon Does any know how to remove volume control in system tray with script? I know how to do it manual by going in Sound and audio Devices and un-check "Place volume icon in task bar". I like to do it with script. Thanks in advance. Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159451
  - 17
    - Excel Find/Replace Hyperlinks Hi, I have many Word documents and Excel spreadsheets that have links to an intranet server database. This database has now moved to a new intranet server with a different name. I have a working vbscript that will open all Word docs and replace all old hyperlinks with new. I now need to do the same with the Excel spread sheets. I can modify the script to find and open them but I cannot find any way of doing a global find and replace. If I record a macro in Excel it gives me: Cells.Replace What:="iisold", Replacement:="iisnew", _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:= _ False, ReplaceFormat:=False but I am lost as to achieve this from the script. Any help appreciated. RogerC Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159449
  - 18
    - SendKeys In ACT 1.0 is there anyway I can use the SendKeys method in ACT? if not does act have a similar method? Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159445
  - 19
    - Download file from Microsoft Bulletin page via vbscript? Say I want to script an automatic download of a certain hotfix from Microsoft's website (our remote sales people are bad at following instructions). I can write a script to go to a certain bulletin page, but I'd like it to automatically download the file from the page instead. For example: http://www.microsoft.com/downloads/details.aspx?familyid=FF84E1A5-C90D-40F2-8CF5-23DA3AB296B4&displaylang=en I'd like to pull the file from the download button here. Is there a way to do this via vbscript? Rob Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159443
  - 20
    - Capturing Command Line Utility Output in VB6 Hi there Got a need to run a command line utility and capture the output in my VB6 program. I know I could used the WScript object and get the STDOUT data via a textstream (all nice and neat)...HOWEVER.... Using the .exec method causes a DOS window to flick on/off. Does anyone know a way that I could use WScript to run a command line utility (so I can get the output in an ordered fashion) but NO window showing. The .run method (like shell) allows for a hidden window...but not easy to get the output (or is it? Anyone know a good way...please let me know). Any help much appreciated Many thanks Mike Finister Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159441
  - 21
    - Automatically Populate Username and Password in Ie Windows Authentication Input Box We are trying to automate the process of getting shipping rate quotes from various shipping company web sites. Some of the web sites present an input dialog box asking for a username and password when you click login. (For example: when I navigate to http://www.myyellow.com there is a logon link. When I click on the link a separate authentication input box entitled "Connect to www.myyellow.com" pops up and has a username field and a password field. http://www.roadway.com does the same thing) Is there anyway to programmatically populate the windows authentication input box username and password field automatically without using SendKeys? If so, does anybody have some example code for doing this? Thanks in advance, Shawn Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159439
  - 22
    - Parsing MSSecure.xml for a child node when the parent node is known, using vbscript Ok, I'm parsing a shavlik output xml file (using HFNETCHK), which lists a series of hotfixes that are not installed on a PC. I can successfully read nodes/values from this XML file with no problems. I am attempting to cross-reference two values from the output xml file - as my script parses the output xml, it finds out a) missing bulletin IDs b) hotfix exe for each bulletin ID In my function that is called when each missing patch is parsed, I wish to pull information from mssecure.xml using those two parameters as identifying selectors(?). The end result is that I want to find out the patchlocationID from mssecure.xml for that appropriate bulletin ID where it matches the patchname (hotfix exe). So, for example, my input parameters might be (BulletinID) MS02-055, and (PatchName) Q323255_WXP_SP2_x86_ENU.exe. I can get my script to select the appropriate bulletin ID node from the mssecure.xml file, but I can't seem to get it to bring me the values of certain child nodes and their attributes. There are about 2 or 3 total patch nodes that appear under Bulletin, but this is the one that I want it to find and return "PatchLocationID" for. Anyone? <BulletinDatastore DataVersion="1.1.2.115" LastDataUpdate="6/8/2004" SchemaVersion="1.0.0.11" LastSchemaUpdate="6/1/2004" ToolVersion="4.0" MBSAToolVer="1.1.1" MBSAToolURL="http://www.microsoft.com/technet/security/tools/Tools/MBSAhome. asp" EIToolVer="2.2.0" RevisionHistory="Shavlik MSSecure XML File" Fmt="MS" SWLABR="blahblah"> <Bulletins> <Bulletin BulletinID="MS02-055" BulletinLocationID="73" FAQLocationID="73" FAQPageName="FQ02-055" Title="Unchecked Buffer in Windows Help Facility Could Enable Code Execution (Q323255)" DatePosted="2002/10/02" DateRevised="2002/10/02" Supported="Yes" Summary="Big ass description" Issue=""> <BulletinComments/> <QNumbers> <QNumber QNumber="Q323255"/> </QNumbers> <Patches> <Patch PatchName="Q323255_WXP_SP2_x86_ENU.exe" PatchLocationID="1502" SBID="0" SQNumber="Q323255" NoReboot="1" MSSeverityID="1" BugtraqID="5874" CVEID="CAN-2002-0693"> <PatchComments/> <AffectedProduct ProductID="120" FixedInSP="0"> <AffectedServicePack ServicePackID="158"/> <AffectedServicePack ServicePackID="216"/> </AffectedProduct> <AffectedProduct ProductID="121" FixedInSP="0"> <AffectedServicePack ServicePackID="158"/> <AffectedServicePack ServicePackID="216"/> </AffectedProduct> <FileChgs> <FileChg FileChangeID="2114"/> </FileChgs> <RegChgs> <RegChg RegChangeID="1314"/> </RegChgs> </Patch> </Bulletin> </Bulletins> Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159431
  - 23
    - Success creating remote folders... now I want to share the folders Hello, I've looked through previous posts and I've seem lots of discussion regarding remotely creating folders... that's not the problem, I can create them no problem but my question is how do I share the newly created folders??? Here's a snip of the code... 1. Dim computerName = "oaw1" 2. Dim folderName = "Scenarios" 3. Dim shareName = "Scenarios" 4. ' I suppose I could just use one of the two variables twice in line 14. 5. const FILE_SHARE = 0 6. 7. Set FSO = CreateObject("Scripting.FileSystemObject") 8. If Not FSO.FolderExists("\\" & computerName & "\c$\" & folderName) Then 9. FSO.CreateFolder("\\" & computerName & "\c$\" & folderName) 10. End If 11. 12. Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & computerName & "\root\cimv2") 13. Set objNewShare = objWMIService.Get("Win32_Share") 14. makeShare = objNewShare.Create (folderName, shareName, FILE_SHARE, , "Test Comments") I'm good through line 10. I don't get any errors at all from this script but when I go to the remote computer (oaw1), right click on the newly created "Scenarios" folder, and select the Sharing tab from the properties, the folder is not set to be shared. Any suggestions on how to get the remote folders shared from this script would be greatly appreciated. Thanks, --CW Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159430
  - 24
    - paging in ASP - VBScript hi, I have a recordset that has about 200 records and I want to only display 20 records at a time. Is there a simpler way to do this other than inserting a for loop? thanks rafael Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159428
  - 25
    - Find Julian Date Hello, Is there a way to find the Julian Date using VBScript? Thanks, Andy. Tag: ODBC query in PWS -vs- IIS 5.1 Tag: 159426

I've developed an ASP application running in Personal Web Server in Win98. All my ODBC queries on that server runs smoothly but when I decided to use IIS 5.1 in WinXP, queries that update my Access Database did not work and give an error "must use an updateable query". What could be the conflicts between using PWS and IIS? What should I do so that my same queries runs in IIS?

Top

Re: ODBC query in PWS -vs- IIS 5.1 by Roland

Roland
Fri Jun 18 03:03:55 CDT 2004

"theMAnn" wrote in message
news:43206F67-54B3-4D7C-BBCB-92230B11B23E@microsoft.com...
: I've developed an ASP application running in Personal Web Server in Win98.
All my ODBC queries on that server runs smoothly but when I decided to use
IIS 5.1 in WinXP, queries that update my Access Database did not work and
give an error "must use an updateable query". What could be the conflicts
between using PWS and IIS? What should I do so that my same queries runs in
IIS?

Generally this error is caused by a permission issue where the IUSR account
needs modify rights to the database.
You also should consider using the Jet OLEDB provider since the ODBC has
been deprecated.

http://able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMicrosoftJet

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

Top