This will only help applications such as Microsoft SQL Server Linked Server that do not use scrollable cursors for other reasons than adding new rows. I'm waiting to hear from the DBA. Hey Goodboy, I am not sure whether this will be helpful to you or not .. What may the reason to get the above error? have a peek here
Please advise me what am I doing wrong. Help others & share knowledge Earn cash & points Learn & ask questions Join The Community 1 Participant ghp7000 LVL 13 DB213 3 Comments LVL 13 Overall: Level 13 DB2 Log in to reply. did you try creating a new connection? https://www.ibm.com/support/docview.wss?uid=swg1IC87917
More Business Intelligence Groups Your account is ready. AnilFocus replied Jul 15, 2005 Hi Ron, Thanks for your reply=2E Ron am able to connect to DB2 and execute standard sql queries from my FEX code=2E The problem is with Technote (FAQ) Question Attempting to perform certain operations using the DB2 Content Manager Client for Windows results in the following error: [IBM][CLI Driver] CLI0150E Driver not capable. Covered by US Patent.
Answer If you are able to log on to the DB2 Content Manager Client for Windows and perform basic operations such as import, search, and retrieve and are also able to After i changed to FOR cursor. SystemAdmin 110000D4XK 6772 Posts Re: CLI0150E Driver not capable. ruby-dude commented Jan 29, 2016 yes, thank you.
Related information DESCSTAT DB2 subsystem parameter Document information More support for: Content Manager for z/OS Library Server Software version: 8.2, 8.3 Operating system(s): OS/390 Reference #: 1258400 Modified date: 20 October All rights reserved. SQLSTATE Actually, the connection does work and we do use a special userid and password. See the referenced DB2 technote for a DESCSTAT discussion.
Collaborator arvindgu commented Jan 29, 2016 Can we close this? SQLSTATE=S1C00" issue. Back to top scott copelandForum EnthusiastJoined: 15 Aug 2002Posts: 1219Location: State AG, Tallahassee, FL Posted: Fri Apr 22, 2005 12:06 pmPost subject: Re: [IBM][CLI Driver] CLI0150E Driver not capable. Enroll to learn HTML5 and prepare for certification.
Join our community for more solutions or to ask questions. https://www.experts-exchange.com/questions/20875947/Error-CLI0150E-Driver-not-capable.html SQLSTATE=HYC00 2010-09-14T00:28:57Z This is the accepted answer. Error description When calling SQLDescribeParam() on a prepared statement for a stored procedure running on DB2 for z/OS, it may fail with the following error: [IBM][CLI Driver] CLI0150E Driver not capable. There is apparently nothing wrong with the set up but yes as you said something is definitely missing in my attempt to invoke a stored procedure from fex on DB2.
I also tried to create a new universe, but when I go to insert tables, I get the "Error in retrieving tables" with details showing "[IBM][CLI Driver] CLI0150E Driver not capable. navigate here SQLSTATE Thanks Ravi! Show: 10 25 50 100 items per page Previous Next Feed for this topic United States English English IBM® Site map IBM What's new? The database is DB2.
The problem is with simple stored procedure call only. Watson Product Search Search None of the above, continue with my search "CLI0150E Driver not capable." error may occur when calling SQLSetPos() with SQL_ADD and SQL_LOCK_NO_CHANGE arguments micrsoft; linked; server; odbc; It's free for Premium Members, Team Accounts, and Qualified Experts. Check This Out You signed out in another tab or window.
SQLSTATE=HYC00 2010-09-17T01:42:02Z This is the accepted answer. Can you share it please? You might make sure that the ID that you're using has the rights to execute one on DB2 and that the DB2 CAE has those privileges too.
The stored procedure compiled successfully &ran successfully initially. The FOCUS & WebFOCUS group is no longer active. Join Now For immediate help use Live now! this contact form DB2 Content Manager clients use the DB2 CLI interface, and as such require that DESCSTAT be set to yes.
I then tried to bind the parameters and this is where it's failing and giving me an error I can't figure out: warning: Describe Param Failed: [IBM][CLI Driver] CLI0150E Driver not if this is still an issue and you would like to dig into the problem i would ask for two things, ok three.. It's weird because I have the connectivity. Thanks, Ravinder Pulijala January 28, 2014 at 07:20 AM 0 Likes Not what you were looking for?
Do your connections have a user ID embedded in them or does it use your BO login ID? SQLSTATE=42808. SQLSTATE=S1C00". Regards Anil Passi Join this group 3Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...
Posted: Fri Apr 22, 2005 10:01 amPost subject: Re: [IBM][CLI Driver] CLI0150E Driver not capable. I have been told that the "tables" that I see in Designer when I open these universes are actually views. Join the community of 500,000 technology professionals and ask your questions. Waiting for ur replies Regards Saravanan 0 Comment Question by:mailsaravanan Facebook Twitter LinkedIn https://www.experts-exchange.com/questions/20875947/Error-CLI0150E-Driver-not-capable.htmlcopy [X] Welcome to Experts Exchange Add your voice to the tech community where 5M+ people just like