Jump to content
  1. Graeme


  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By hugomito
      Hi all,
      I am having issues connecting to an MSSQL DB from a MacBook. The following code works fine from Windows 7 and Windows 10, but it is not working from MacBook.
      #include <file.au3> $obj_ErrorHandling = ObjEvent ("AutoIt.Error", "f_ErrorHandling") Const $c_SCRIPTNAME = StringLeft(@ScriptName, StringLen(@ScriptName) - 4) Const $c_EAILogFile = @ScriptDir & "\" & $c_SCRIPTNAME & "_" & StringUpper (@UserName) & ".log" Const $c_SCRIPTLOGFILE = FileOpen ($c_EAILogFile, $FO_OVERWRITE) FileWrite ($c_SCRIPTLOGFILE, "[INFORMATION] Variables definition" & @CRLF) $txt_UserId = "User123" $txt_Password = "Password123" $txt_ProviderDatasource = "Provider=SQLOLEDB;Data Source=server.companyname.com\ss123; Initial Catalog=MyTools; User ID=" & $txt_UserId & "; Password=" & $txt_Password FileWrite ($c_SCRIPTLOGFILE, "[INFORMATION] Creating object" & @CRLF) $conn_Database = ObjCreate ("ADODB.Connection") FileWrite ($c_SCRIPTLOGFILE, "[INFORMATION] Initializing connection string" & @CRLF) $conn_Database.ConnectionString = $txt_ProviderDatasource FileWrite ($c_SCRIPTLOGFILE, "[INFORMATION] Connecting to Database" & @CRLF) $conn_Database.Open FileWrite ($c_SCRIPTLOGFILE, "[INFORMATION] Database connected" & @CRLF) Func f_ErrorHandling ($obj_ErrorHandling) $HexNumber = Hex ($obj_ErrorHandling.number, 8) FileWrite ($c_SCRIPTLOGFILE, "[INFORMATION] Error occured while connecting Database!" & @CRLF) MsgBox (0, $c_SCRIPTNAME, "We intercepted a COM Error !" & @CRLF & @CRLF & _ "Error Number: " & $obj_ErrorHandling.Number & @CRLF & _ "Error Description: " & $obj_ErrorHandling.description & @CRLF & _ "Error WinDescription:" & $obj_ErrorHandling.windescription & @CRLF & _ "Error Last DLLL Error: " & $obj_ErrorHandling.lastdllerror & @CRLF & _ "Error Script Line: " & $obj_ErrorHandling.scriptline & @CRLF & _ "Error Source: " & $obj_ErrorHandling.source) SetError(1) Exit (1) EndFunc After executing it in a MacBook, the log file contains:
      [INFORMATION] Variables definition
      [INFORMATION] Creating object
      [INFORMATION] Error occured while connecting Database!
      And the error message is attached to this post.
      Can anyone guide me how to resolve this issue?
      Thanks in Advance.

    • By Danp2
      UDF to control FireFox via MozRepl:
      Change Log:
      Original thread: http://www.autoitscript.com/forum/topic/95595-ffau3-v0601b-10/
    • By mattia100
      1) I want to create a FF web page in background... i want to say a web page that can't be seen in the application bar  but only in Windows Task Manager... 
      maybe using  __FFStartProcess? in fact i tried to use it but the parameter "hide" only can minimize the page, but not put it in background... 
      2) After creating this hide page, i would to open a macro of the iMacros addon, always all in hide mode...
      it is possible to do it?
      anybody can help me?
    • By 5ervant
      Go create a quick account in Zapier and go to https://zapier.com/app/dashboard and make some Zaps!
      Just need to click the specific instance of an .open-menu button and then click its a.run (anchor) element.
      Doing this IE.au3 script just causing to click its container element:
      $target = 1; Target the first instance #include <IE.au3> $oIE = _IEAttach("Dashboard - Zapier") $count = 0; $tags = _IETagNameGetCollection($oIE, "div") For $tag in $tags $class_value = $tag.GetAttribute("class") If $class_value = "open-menu" Then $count += 1 if $count = $target Then MsgBox(0, "Instance: ", $count) ; $tag.fireEvent("onmousedown") ; _IEAction($tag, "click") ; $tag.fireEvent("onmouseup") ; Or this but not working ; $tag.Click EndIf EndIf Next I also tried to do it using FF.au3
      $target = 1; Target the first instance #Include <Array.au3> #Include <FF.au3> $count = 0; If _FFConnect(Default, Default, 3000) Then $aArray = _FFXPath( "//div[@class='open-menu']", "", 7 ) ; _ArrayDisplay($aArray) For $tag in $aArray $count += 1 if $count = $target Then MsgBox(0, "Instance: ", $count) _FFClick($tag) EndIf Next EndIf Error: _FFClick ==> No match: $sElement: [number]
      Could some help me how to click such buttons on such kind of a dynamic page?
    • By jfcby
      I have a script that sends multiple lines of text to a textbox using Firefox. I using _FFSetValue($sCellValue[7], "line one" & @CR & "line two", "id") from ff.au3. If it's a single line of text it works but MozRepl give the following error with multiple lines of text.
      __FFSend: try{FFau3.simulateEvent(window.content.top.document.getElementById('line one
      line two'),'Event','change',13);}catch(e){'_FFCmd_Err';};
      __FFWaitForRepl ==> Error return value: MozRepl ....>
      __FFSend: ;
      __FFSend: FFau3.WCD=window.content.top.document;
      __FFWaitForRepl ==> Error return value: MozRepl ....>
      __FFRecv: !!! SyntaxError: unterminated string literal

       [object HTMLDocument] - {mainForm: {...}, location: {...}, getElementsByName: function() {...}, getItems: function() {...}, open: function() {...}, close: function() {...}, write: function() {...}, ...}
      !!! SyntaxError: unterminated string literal
      Will MozRepl plugin for Firefox send multiple lines of text to a textbox?
      Thanks for your help.
  • Create New...