Db2 Error No Error Information Available
Topic: Window 7 support 8 replies Latest Post - 2010-04-23T16:20:31Z by asp1028 Display:ConversationsBy Date 1-9 of 9 Previous Next asp1028 270000DBCX 66 Posts Pinned topic Window 7 support 2010-04-13T19:21:33Z | Tags: Answered question This question has been answered. Unanswered question This question has not been answered yet. Is there any good news in running Express-C (DB2Client) in W7? Thanks, Frank Log in to reply. Updated on 2010-04-23T16:20:31Z at 2010-04-23T16:20:31Z by asp1028 SystemAdmin 110000D4XK 5837 Posts Re: Window 7 support 2010-04-14T14:38:26Z This is the accepted answer. This is the accepted answer. Hi,Frank DB2 9.7 supports Windows 7. http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.fresh.doc/com.ibm.db2.luw.qb.server.doc/doc/r0006867.html?noframes=true and you can download DB2 9.7.1 express-c now. Log in to reply. asp1028 270000DBCX 66 Posts Re: Window 7 support 2010-04-14T14:52:08Z This is the accepted answer. This is the accepted answer. SystemAdmin 110000D4XK 2010-04-14T14:38:26Z Hi,Frank DB2 9.7 supports Windows 7. http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.fresh.doc/com.ibm.db2.luw.qb.server.doc/doc/r0006867.html?noframes=true and you can download DB2 9.7.1 express-c now. More... That is good news, thanks. Log in to reply. asp1028 270000DBCX 66 Posts Re: Window 7 support 2010-04-14T19:31:50Z This is the accepted answer. This is the accepted answer. SystemAdmin 110000D4XK 2010-04-14T14:38:26Z Hi,Frank DB2 9.7 supports Windows 7. http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.fresh.doc/com.ibm.db2.luw.qb.server.doc/doc/r0006867.html?noframes=true and you can download DB2 9.7.1 express-c now. More... I am actually looking for the DB2Client, wonder is that a separate install for W7. The 9.7.1 installs the entire DB. I have the DB running on Vista/XP and works fine. Only the development DB2Client is not working in W7. Thanks, Frank Log in to reply. asp1028 270000DBCX 66 Posts Re: Window 7 support 2010-04-15T00:45:27Z This is the accepted answer. This is the accepted answer. asp1028 270000DBCX 2010-04-14T19:31:50Z I am actually looking for the DB2Client, wonder is that a separate install for W7. The 9.7.1 installs the entire DB. I have the DB running on Vista/XP and works fine. Only the development DB2Cli
SonicWALL User Sorry, we are having issues processing your request. If you own the SonicWALL product requested please confirm that you have registered your product at My SonicWALL . If you have already registered your product then please contact Customer Service directly for further assistance at customerservice@software.dell.com. Continue Search Sign In Sign In Create Support Account Products ActiveRoles Boomi Change Auditor Foglight Identity Manager KACE Migration Manager Rapid Recovery Recovery Manager SharePlex SonicWALL Spotlight Statistica Toad View all https://www.ibm.com/developerworks/community/forums/thread.jspa?threadID=325214 Products Solutions Application & Data Integration Big Data Analytics Business Intelligence Cloud Management Data Protection Overview Backup and Recovery Deduplication and Compression Database Development & Management Database Replication & Backup Endpoint Management Mobile Workforce Management Overview Desktop Virtualization Enterprise Mobility Management Endpoint Security Network Security Secure Remote Access Performance Monitoring Security Overview Email Security Endpoint Security Identity & https://support.software.dell.com/toad-for-db2/kb/77366 Access Management Network Security Secure Remote Access Virtualization Management Microsoft Platform Management View all Solutions Solutions by Platform Active Directory Exchange Google GroupWise & NDS Hadoop Hyper-V Lotus Notes Skype for Business/Lync Office 365 Oracle SharePoint SQL Server VMware Trials Buy Support By Product Line Enterprise Reporter Foglight KACE Migration Manager Migrator NetVault One Identity Quick Connect Performance Analysis Recovery Manager Shareplex SonicWALL Spotlight SQL Navigator Toad All Products Contact Support Download Software Knowledge Base My Account My Products My Service Requests My Licenses My Groups My Profile Policies & Procedures Professional Services Technical Documentation Training & Certification User Forums Video Tutorials Support Home Communities Partners × Email Share your favorite Support content with a friend. Email To Email From Subject Information from Dell Software Support Message You might be interested in the following information For more information regarding support on your Dell Software Product, please visit www.software.dell.com/support Print Email My Downloads () Support Knowledge Base Toad for DB2 Errors: "ERROR - no error information available" and "SQL10007N Message "-1390" c
Events Forums DB2-LDB2-L ArchivesNA ConferenceEMEA Conference Resources BlogsIDUG eBulletinIDUG NewsroomCommunitiesRegional User Groups Articles&Content IDUG Content ArticlesTech ChannelBeginner's BlogDB2 Hot Topics BlogContent LibraryIDUG YouTubePast Conference ContentCodeplace Library GetInvolved Volunteering with IDUGVolunteer PositionsJoin a Regional User GroupBecome an IDUG MentorSponsorship http://www.idug.org/p/fo/et/thread=20887 OpportunitiesJoin a CommunitySpeaker Community DB2 Connect Problem? Chris Worthington DB2 Connect Problem? https://bytes.com/topic/db2/answers/183887-ibm-db2-connector-throws-exception-connect-net June 15, 2005 10:37 AM Environment: DB2 Connect V8.1.3 FP3, DB2 z/OS V7.1, MS Visual Studio .NET 2003 (7.1.3088) The problem occurs when trying to run a stored procedure from within MS Visual Studio using the IBM Explorer Add-in. It appears limited to sp’s defined with output parameters. db2 error The sp is being executed correctly on the server but the following error is reported in the IBM DB2 Output Message Pane (within VS .NET)… Transaction began Executing RoutineSYSPROC.GETAROFFSETTRNS 0: Error occured: [IBM][CLI Driver][DB2] SQL0303N A value cannot be assigned to a host variable in the SELECT, VALUES, or FETCH statement because the data types are not compatible. SQLSTATE=42806 : -303: db2 error no IBM.Data.DB2: 42806 Also within Visual Studio (from the Report Designer for SSRS) I receive the following error message when trying to call any stored procedure (using the IBM OLE Provider for DB2 - IBMDADB2) "An error occurred while executing the query. No error information available. DB_E_NOCOMMAND(0x80040E0C)" Are both of these problems DB2 Connect related? Assuming they are, is there a Fixpak that corrects these issues? TIA. Chris Worthington. --------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm David W Nobles Re: DB2 Connect Problem? June 21, 2005 05:45 PM (in response to Chris Worthington) Chris, Did you ever figure out if your problem was due to DB2 Connect? As I mentioned earlier we are upgrading from v7 to v8.1 (was FP8 but due to many of the replies I received earlier it will be F
a Question Need help? Post your question and get tips & solutions from a community of 418,478 IT Pros & Developers. It's quick & easy. IBM DB2 Connector throws exception with .Connect() in .net P: n/a C.E.O. Gargantua I am using the IBM DB2 Connector class of the Redistributable DB2 Run-Time Client Lite in a c# .net application using Visual Studio. Running the code: string myConnString = "DATABASE=192.168.1.43;UID=XXXX;PWD=XXXX"; DB2Connection myConnection = new DB2Connection(myConnString); myConnection.Open(); Throws this error on the .Open() method: IBM.Data.DB2.DB2Exception: ERROR [HY009] [IBM] CLI0124E Invalid argument value. SQLSTATE=HY009 at IBM.Data.DB2.d.a(String A_0, Int32 A_1, IsolationLevel A_2, DB2Connection A_3) at IBM.Data.DB2.DB2ConnPool.a(DB2Connection A_0, String A_1, a& A_2, Object& A_3) at IBM.Data.DB2.DB2Connection.Open() at dot400.Form1.processSqlRequest(String qs, Int32 q) in c:\documents and settings\jbailo\my documents\visual studio projects\dot400\form1.cs:line 205 How can I diagnose this? Does my connection string look right? The machine name on our network is AS400. If I use that as the DATABASE name, it throws another error: IBM.Data.DB2.DB2Exception: ERROR [58031] [IBM] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031 at IBM.Data.DB2.d.a(String A_0, Int32 A_1, IsolationLevel A_2, DB2Connection A_3) at IBM.Data.DB2.DB2ConnPool.a(DB2Connection A_0, String A_1, a& A_2, Object& A_3) at IBM.Data.DB2.DB2Connection.Open() at dot400.Form1.processSqlRequest(String qs, Int32 q) in c:\documents and settings\jbailo\my documents\visual studio projects\dot400\form1.cs:line 205 I can access this as400 using OleDb ( the SQLDA400 data provider that is part of the CAE ), but I want to deploy my application using the Here is the connector class api doc: http://publib.boulder.ibm.com/infoce...ClassTopic.htm -- incognito () Updated Almost Daily http://kentpsychedelic.blogspot.com Nov 12 '05 #1 Post Reply Share this Question 7 Replies P: n/a Frans Bouma [C# MVP] C.E.O. Gargantua wrote: I am using the IBM DB2 Connector class of the Redistributable DB2 Run-Time Client Lite in a c# .net application using Visual Studio. Running the code: string myConnString = "DATABASE=192.168.1.43;UID=XXXX;PWD=XXXX"; this isn't corr