Error While Connecting MS SQL DB from MacBook

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

[BrewManNH]

AutoIt isn't designed to work on anything other than Windows, good luck getting it to work on something that's not Windows.

[hugomito]

Oops!

Thanks for your guidance and prompt response.

Regards,