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.

UDF to control FireFox via MozRepl:
 FF_V0.6.0.1b-15_au3
Change Log:
Original thread: http://www.autoitscript.com/forum/topic/95595-ffau3-v0601b-10/
 

HI!
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?
Thanks!!

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?

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.
Error:  
__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: ;
__FFRecv:
__FFSend: FFau3.WCD=window.content.top.document;
__FFWaitForRepl ==> Error return value: MozRepl ....>
__FFRecv: !!! SyntaxError: unterminated string literal
Details:

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