uberis

Sorry but I have emptied my cache different times and also used different browser but the result is always the same: the downloaded file when startet indicates that version 3.2.10.0 will be installed.

You are right but the download button refers to a file that represents version 3.2.10.xx but not 3.2.12.0

Thank you for your reply but that is a beta version 3.2.11.xx and not the final one which is announced as 3.2.12.0.Regards

What do you mean with last option? Can you post a link where to find that last option?Thanks.

Hi, the download refers to the version 3.2.10.0 instead of 3.2.12.0. Is the new version not available for public download yet? uberis

Thanks a lot you guys, that was the trick I was looking for. Greetings uberis

Hi folks, has anybody found a way how to change the background colour of a splashtext window (per default it is light grey coloured)? I know, that there is no support of the function itself, but I also tried dll-calls but witout success so far. Greetings uberis

Hi, I attach an example of a successful connect to an oracle database, calling a stored procedure with 1 return flag, 3 input parameters as variables and also 3 output parameters. Hope that it can give you some idea of working with oracle databases. ; ------------------------------------------------------------------- ; function: Access_DB ; Access oracle database and get required information ; ------------------------------------------------------------------- Func Access_Oracle_DB() Local $objconn, $objCmd, $objRS, $objPara ; we set up the required oracle environment $aOraPath = '\\(server)\(ora_instdir)\bin;\\\\(server)\(ora_instdir)\network\admin;' $aOraHome = '\\\\(server)\(ora_instdir)' $aOraTNS = $aOraHome & '\network\admin' $aOraNLS = 'GERMAN_GERMANY.WE8ISO8859P1' $aPath = EnvGet("Path") EnvSet("Path", $aPath & ';' & $aOraPath) EnvSet("ORACLE_HOME", $aOraHome) EnvSet("TNS_ADMIN", $aOraTNS) EnvSet("NLS_LANG", $aOraNLS) EnvUpdate() ; some variable definition for accessing the oracle com objects $adUseServer = 2 $adUseClient = 3 $adCmdText = 1 $adCmdStoredProc = 4 $adBSTR = 8; null terminated chr string $adVariant = 12 $adChar = 8 $adVarChar = 200 $adIN = 1 $adOUT = 2 $adINOUT = 3 $adParamReturnValue = 4 ;direction of variables that return a e.g. a flag ; definition of the database connection ; pls exchange all values in square brackets with real values out of you environment !!!! ;$DBDsn = "Driver={Microsoft ODBC for Oracle};" & _ ; "Connectstring=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=[hostname])(PORT=[portno])) " & _ ; "(CONNECT_DATA=(SERVER = DEDICATED)(SERVICE_NAME=[name of the oracle db])));" & _ ; "Uid=[uid];Pwd=[pw];" ;$DBDsn = "Driver={Microsoft ODBC for Oracle};Server=[name of the oracle db];Uid=[uid];Pwd=[pw];" $DBDsn = "Provider=MSDAORA;User ID=[uid];Password=[pw];Data Source=[name of the oracle db];" $objConn = ObjCreate("ADODB.Connection") $objCmd = ObjCreate("ADODB.Command") $objRS = ObjCreate("ADODB.Recordset") $objParam = ObjCreate("ADODB.Parameter") ; we connect to the database With $objConn .ConnectionString = $DBDsn .CursorLocation = $adUseClient .Open Endwith ; we build up the oracle command to be executed $var1_in = 'name of my pc' $var2_in = 'Adobe Acrobat Professional' $var3_in = '7.0' With $objCmd .ActiveConnection = $objConn .CommandText = "[name of your stored procedure/package]" .CommandType = $adCmdStoredProc ;.Parameters.Refresh ;.Properties("PLSQLRSet") = TRUE ; syntax: (variable_name, variable_typ, direction, length) $objParm = .CreateParameter("retflag", $adVarChar, $adParamReturnValue, 1); in this case it returns Y or N .Parameters.Append ($objParm) $objParm = .CreateParameter("var1_in", $adVarChar, $adIN, 20) $objParm.Value = $ora_pc_name_in .Parameters.Append ($objParm) $objParm = .CreateParameter("var2_in", $adVarChar, $adIN, 60) $objParm.Value = $ora_sw_name_in .Parameters.Append ($objParm) $objParm = .CreateParameter("var3_in", $adVarChar, $adIN, 15) $objParm.Value = $ora_sw_rev_in .Parameters.Append ($objParm) $objParm = .CreateParameter("var1_out", $adVarChar, $adOUT, 60) .Parameters.Append ($objParm) $objParm = .CreateParameter("var2_out", $adVarChar, $adOUT, 60) .Parameters.Append ($objParm) $objParm = .CreateParameter("var3_out", $adVarChar, $adOUT, 60) .Parameters.Append ($objParm) ;.NamedParameters .Execute $ret = @error MsgBox(0,"",'Parm0: N=' & .Parameters(0).name & '/V=' & .Parameters(0).Value & '/D=' & .Parameters(0).Direction & @CRLF & _ 'Parm1: N=' & .Parameters(1).name & '/V=' & .Parameters(1).Value & '/D=' & .Parameters(1).Direction & @CRLF & _ 'Parm2: N=' & .Parameters(2).name & '/V=' & .Parameters(2).Value & '/D=' & .Parameters(2).Direction & @CRLF & _ 'Parm3: N=' & .Parameters(3).name & '/V=' & .Parameters(3).Value & '/D=' & .Parameters(3).Direction & @CRLF & _ 'Parm4: N=' & .Parameters(4).name & '/V=' & .Parameters(4).Value & '/D=' & .Parameters(4).Direction & @CRLF & _ 'Parm5: N=' & .Parameters(5).name & '/V=' & .Parameters(5).Value & '/D=' & .Parameters(5).Direction & @CRLF & _ 'Parm6: N=' & .Parameters(6).name & '/V=' & .Parameters(6).Value & '/D=' & .Parameters(6).Direction) ;.Properties("PLSQLRSet") = FALSE Endwith $objConn.Close EndFunc ;==>Access_DB Greetings uberis

@ptrex Thank you for your support and the link for that documentation. I will give it a try to see if I get my task running. uberis

Hi, I have connected to an oracle db successfully, but I am still struggling with calling stored procedures, especially when there is a need to supply it with parameters (input as well as output). When I try it with the command object, no record sets are retrieved. Has anybody has had success in accessing and providing a stored procedure with parameters? Greetings Harald

Hi there everybody, is there any way to use this magnific GUI Hyperlink control with colouring and sizing the hyperlink itself, e.g. the text is in size Arial 10 and coloured black, but I want to have the hyperlink to appear in size 12 and coloured red. I tried to change the part in the GUIHyperlinkControl.au3 file where the anchor point is repleced with corresponding html commands to be included but did not get the result as expected, means the additional html commands are not used but displayed as text of the link itself. Greetings Harald

@ptrex Thnx a lot for your fast reply. yes, I found that stuff you mentioned in the meantime. I will give it a try to see if it will work with an Oracle database so far. I only thought that one guy might be outside that have had a successful connection to an Oracle database so far.

Hi everybody, does anybody of you ever successfully accessed an Oracle database out of an AutoIt3 script (connect, running an sql, etc.)? If so, does anybody have an example available of how to manage this stuff? Any other 3rd party tools needed? Thx for your help in advance. Harald