Search the Community

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.