Search the Community
Showing results for tags 'connecting'.
-
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.
- 2 replies
-
- mssql
- connecting
-
(and 1 more)
Tagged with:
-
Hi, I'm trying to open a Firefox window with this code - If _ffstart() Then If _ffconnect() Then ;_ffstart() If _ff_openurl("http://english.documentation.ff-au3.thorsten-willert.de/ff_functions/_FFOpenURL.php") Then MsgBox(0,"","It's open") Else MsgBox(0,"","Is there a problem") EndIf Else MsgBox(0,"","Couldn't connect") EndIf EndIf And I get this as a result = __FFStartProcess ==> General Error: Error reading registry entry for FireFox. HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMozillaMozilla Firefox*CurrentVersion*MainPathToExe Error from RegRead: 1 The problem is that the registry entry does oint to the right place for Firefox so what's wrong?? Any ideas please? Blessings Graeme