Jump to content

Search the Community

Showing results for tags 'ADODB SQL errors'.

  • 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


Member Title


Location


WWW


Interests

Found 1 result

  1. I've looked around but i'm having trouble finding what i need. I need to catch the SQL error output for a statement. Example: Global $adoCn = ObjCreate( "ADODB.Connection" ) $adoCn.Properties("Prompt") = 2; 1=PromptAlways, 2=PromptComplete $ConnectionString = "DRIVER={Oracle in instantclient_11_2};data source=src" $adoCn.ConnectionString = $ConnectionString $adoCn.Open If @error Then MsgBox(0, "Problem", "SQL Connection Failed") Else $adoCn.Execute("Blah blah SQL here") ... ?? catch error ? So i can run a SQL statement. and something like "Select * from dba_users" is easy to catch. if my record set is zero then i can do some error code. Problem is i'm trying to write a little tool that can manage passwords. so i want to do an "alter user identified by "xxxx"" Statement. there's no return and if the alter fails i want to get back the error why (maybe password was too weak or other reasons) But @error doesn't seem to contain anything from the sql. in fact i'm not even sure how to continue the script . seems the whole thing just dies with a "The requested action with this object has failed.:" error.
×
×
  • Create New...