Topic
  • 4 replies
  • Latest Post - ‏2011-02-21T20:34:59Z by Trey
goodboy18
goodboy18
99 Posts

Pinned topic CLI0150E Driver not capable. SQLSTATE=HYC00

‏2010-09-13T23:48:05Z |
i am trying to connect to mainframe DB2 version 9.1 using datapower.i was able to configure a data source but when i fire a sql/plsql i got the below error results.

CLI0150E Driver not capable. SQLSTATE=HYC00

wondering what could be the cause?any help will be very useful.the dp XI50 firmware that i am using is 3.8.1.2.
Updated on 2011-02-21T20:34:59Z at 2011-02-21T20:34:59Z by Trey
  • SystemAdmin
    SystemAdmin
    6772 Posts

    Re: CLI0150E Driver not capable. SQLSTATE=HYC00

    ‏2010-09-14T00:28:57Z  
    Hey Goodboy,

    I am not sure whether this will be helpful to you or not .. i find the IBM document for the following error you got ..

    http://www-01.ibm.com/support/docview.wss?uid=swg21258400

    Regards,
    Kumar
  • Trey
    Trey
    227 Posts

    Re: CLI0150E Driver not capable. SQLSTATE=HYC00

    ‏2010-09-17T01:42:02Z  
    if this is still an issue and you would like to dig into the problem i would ask for two things, ok three..
    • disable the SQL object
    • in the sql object options add a "TraceFile" "logtemp:///SQL-trace.log"
    • set the log level to debug
    • enable the SQL object

    Collect the error report, sql-trace.log, and default-log then open a pmr feel free to note this thread and I would be glad to dig in and see what the issue is.
    Thanks
    Trey
  • SystemAdmin
    SystemAdmin
    6772 Posts

    Re: CLI0150E Driver not capable. SQLSTATE=HYC00

    ‏2011-02-21T17:42:23Z  
    • Trey
    • ‏2010-09-17T01:42:02Z
    if this is still an issue and you would like to dig into the problem i would ask for two things, ok three..
    • disable the SQL object
    • in the sql object options add a "TraceFile" "logtemp:///SQL-trace.log"
    • set the log level to debug
    • enable the SQL object

    Collect the error report, sql-trace.log, and default-log then open a pmr feel free to note this thread and I would be glad to dig in and see what the issue is.
    Thanks
    Trey
    Trey,

    Was there a fix to the issue? Can you share it please?

    Thanks
    Nilesh
  • Trey
    Trey
    227 Posts

    Re: CLI0150E Driver not capable. SQLSTATE=HYC00

    ‏2011-02-21T20:34:59Z  
    Trey,

    Was there a fix to the issue? Can you share it please?

    Thanks
    Nilesh
    Nilesh,
    There is no current apar for this and no other reports of it from clients.
    It sounds like something set in the sql config that should not be there OR something passed in a name/value parameters.

    If you can reproduce this enable the "TraceFile" "logtemp:///SQL-trace-log" to the data source on DP and set the log level to debug.

    Send through a single transaction to trigger the event then open a pmr and send in the log with all of the tracefiles created. (there will be one trace log per sql connection)

    You are welcome to note my name in the pmr when you open it.
    Thank you
    Trey