Jump to content

Search the Community

Showing results for tags 'oracle'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • General
    • Announcements and Site News
    • Administration
  • AutoIt v3
    • AutoIt Help and Support
    • AutoIt Technical Discussion
    • AutoIt Example Scripts
  • Scripting and Development
    • Developer General Discussion
    • Language Specific Discussion
  • IT Administration
    • Operating System Deployment
    • Windows Client
    • Windows Server
    • Office

Categories

  • AutoIt Team
    • Beta
    • MVP
  • AutoIt
    • Automation
    • Databases and web connections
    • Data compression
    • Encryption and hash
    • Games
    • GUI Additions
    • Hardware
    • Information gathering
    • Internet protocol suite
    • Maths
    • Media
    • PDF
    • Security
    • Social Media and other Website API
    • Windows
  • Scripting and Development
  • IT Administration
    • Operating System Deployment
    • Windows Client
    • Windows Server
    • Office

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Location


WWW


Interests

Found 4 results

  1. Hi all! I'm trying to make unattended installation of Oracle Client with Oracle Universal Installer, but oftenly got false pushes of buttons. I mean, if the code is {TAB 3}{RIGHT 3}{TAB 4}{ENTER}, then one of the block oftenly working like +1, like {TAB 4}{RIGHT 3}{TAB 4}{ENTER}, what's I don't want to. How to avoid such behavior of AutoIt and does AutoIt have a problems with Java apps (due different windows style)? A script designed for x32 systems and it's ran on x32 systems. OS: Windows 7 (x32), 1 Gb RAM Run("D:\temp\setup.exe") ;welcome Sleep (8000) WinWait("Oracle Universal Installer") WinActivate("Oracle Universal Installer") WinWaitActive ("Oracle Universal Installer") Send ("{ENTER}") ;select installation type Sleep (7000) WinWait("Oracle Universal Installer") WinActivate("Oracle Universal Installer") WinWaitActive ("Oracle Universal Installer") Send ("{TAB 3}{RIGHT 3}{TAB 4}{ENTER}") ;specify home details Sleep (7000) WinWait("Oracle Universal Installer") WinActivate("Oracle Universal Installer") WinWaitActive ("Oracle Universal Installer") Send ("{TAB 3}") Send ("C:\Oracle") Send ("{TAB 5}{ENTER}") ;avaible product components Sleep (7000) WinWait("Oracle Universal Installer") WinActivate("Oracle Universal Installer") WinWaitActive ("Oracle Universal Installer") Send ("{TAB 2}{DOWN 21}{SPACE}{TAB 6}{ENTER}") ;product specific checks Sleep (5000) Switch @OSVersion Case "Win_XP" Send ("{ENTER}") Case "Win_Vista" Send ("{ENTER}") Case Else Send ("{TAB 2}{RIGHT 2}{SPACE 2}{TAB 3}") Send ("^{TAB}{TAB 3}{ENTER}") EndSwitch ;summary Sleep (5000) WinWait("Oracle Universal Installer") WinActivate("Oracle Universal Installer") WinWaitActive ("Oracle Universal Installer") Send ("{ENTER}") ;Oracle Net Configuration Assistant: Welcome Sleep (50000) WinWait("Oracle Net Configuration Assistant") WinActivate("Oracle Net Configuration Assistant") WinWaitActive ("Oracle Net Configuration Assistant") Send ("{ENTER}") ;naming methods configuration Sleep (500) WinWait("Oracle Net Configuration Assistant") WinActivate("Oracle Net Configuration Assistant") WinWaitActive ("Oracle Net Configuration Assistant") Send ("{TAB}{DOWN 4}{ENTER}{TAB 7}{ENTER}") ;net service name configuration Sleep (500) WinWait("Oracle Net Configuration Assistant") WinActivate("Oracle Net Configuration Assistant") WinWaitActive ("Oracle Net Configuration Assistant") Send ("main") Send ("{TAB 4}{ENTER}") ;net service name, select protocol Sleep (500) WinWait("Oracle Net Configuration Assistant") WinActivate("Oracle Net Configuration Assistant") WinWaitActive ("Oracle Net Configuration Assistant") Send ("{ENTER}") ;net service name, tcp/ip protocol Sleep (500) WinWait("Oracle Net Configuration Assistant") WinActivate("Oracle Net Configuration Assistant") WinWaitActive ("Oracle Net Configuration Assistant") Send ("10.7.200.107") Send ("{TAB 6}{ENTER}") ;net service name, test Sleep (500) WinWait("Oracle Net Configuration Assistant") WinActivate("Oracle Net Configuration Assistant") WinWaitActive ("Oracle Net Configuration Assistant") Send ("{ENTER}") ;net service name Sleep (500) WinWait("Oracle Net Configuration Assistant") WinActivate("Oracle Net Configuration Assistant") WinWaitActive ("Oracle Net Configuration Assistant") Send ("{ENTER}") ;another net service name? Sleep (500) WinWait("Oracle Net Configuration Assistant") WinActivate("Oracle Net Configuration Assistant") WinWaitActive ("Oracle Net Configuration Assistant") Send ("{ENTER}") ;net service name done Sleep (500) WinWait("Oracle Net Configuration Assistant") WinActivate("Oracle Net Configuration Assistant") WinWaitActive ("Oracle Net Configuration Assistant") Send ("{ENTER}") ;easy connect naming Sleep (500) WinWait("Oracle Net Configuration Assistant") WinActivate("Oracle Net Configuration Assistant") WinWaitActive ("Oracle Net Configuration Assistant") Send ("{ENTER}") ;naming methods config done Sleep (500) WinWait("Oracle Net Configuration Assistant") WinActivate("Oracle Net Configuration Assistant") WinWaitActive ("Oracle Net Configuration Assistant") Send ("{ENTER}") ;done Sleep (500) WinWait("Oracle Net Configuration Assistant") WinActivate("Oracle Net Configuration Assistant") WinWaitActive ("Oracle Net Configuration Assistant") Send ("{ENTER}") ;end of installation Sleep (1500) WinWait("Oracle Universal Installer") WinActivate("Oracle Universal Installer") WinWaitActive ("Oracle Universal Installer") Send ("{ENTER 2}") Send ("{ENTER}")
  2. Hello all! I've been scouring the interwebs for a whiff of anybody else who's had this problem and come up empty. Here's the deal: I wrote a simple little script that I've used for months now quite successfully, but I'm also experiencing an error where the ODBC login window will pop up, garbage text will automatically dump into the username, password, and sometimes the source fields, and then it will automatically try to log in and cause it to fail. It's intermittent, and I have no idea what's causing it. It happens in databases that I've never automated, but it does exactly what the script I wrote should do except that it's garbage text being entered. I've attached the script I mentioned. I'd appreciate anything anybody can suggest or recommend. Thanks! Send ( "{LWin}" ) Sleep ( 2000 ) Send ("Drive:\Folder\Database.accdb /x Macro") Send ( "{ENTER}" ) WinWaitActive ( "Oracle ODBC Driver Connect" ) Send ( "Username" ) Send ( "{TAB}" ) Send ( "Password" ) ControlClick ( "Oracle ODBC Driver Connect", "OK", 1 )
  3. Hi! anyone with some oracle SQL experience? I want to join 2 tables, where the only possible join is by two different columns. Column A is a twelve character long number, while the other ( B ) is a two character long number. They can ba joined, because A is like .BB......... , So the 2. and 3. char is taken from B (and in no other cases this is possible). I think I should be able to use REGEXP_LIKE but how do I use column data in this function? '.column_name.........' isn't working naturaly. I tried to look around but I'm stuck now. The best would be if I can use the column name in the regex. I thought about manually entering the possible number combinations, but that wold require updates, and I can't allow that. Thank you for your time!
  4. I wanted to see who else is using OATS 12?
×
×
  • Create New...