SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Ravi Kiran
    New Member
    • Aug 2011
    • 2

    SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2

    Hi...I am using DB2 .net provider to connect to mainframe DB from .Net.
    Earlier when compiling the project was facing an error saying, there was a conflict with the IBM.Data.db2.dl l version (9.7.3.2). So then copied a different version (9.1.6.1) dll to C:\Program Files\IBM\SQLLI B\BIN location. Now the project is getting compiled but getting an initialization error with DB2.Net data provider


    Please anyone suggest me what i need to do ?
    Below is the error description
    Thanks

    SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2, tokens C:\Billing Group\NetSoluti ons\DirectBill\ DirectBill_UI\b in\db2app.dll,

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.InvalidO perationExcepti on: SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2, tokens C:\Billing Group\NetSoluti ons\DirectBill\ DirectBill_UI\b in\db2app.dll,

    Source Error:

    Line 63: public class requestData
    Line 64: {
    Line 65: private DB2Connection cnDB2 = new DB2Connection() ;
    Line 66: private DB2Command cdDB2 = new DB2Command();
    Line 67: private DB2DataAdapter daDB2 = new DB2DataAdapter( );


    Source File: c:\billing group\netsoluti ons\directbill\ directbill_da\d irectbill.cs Line: 65

    Stack Trace:

    [InvalidOperatio nException: SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2, tokens C:\Billing Group\NetSoluti ons\DirectBill\ DirectBill_UI\b in\db2app.dll, ]
    IBM.Data.DB2.f. a()
    IBM.Data.DB2.DB 2ConnPool.e()
    IBM.Data.DB2.DB 2ConnPool..ctor ()
    IBM.Data.DB2.DB 2Connection..cc tor()

    [TypeInitializat ionException: The type initializer for "IBM.Data.DB2.D B2Connection" threw an exception.]
    IBM.Data.DB2.DB 2Connection..ct or() +0
    DirectBill_DA.r equestData..cto r() in c:\billing group\netsoluti ons\directbill\ directbill_da\d irectbill.cs:65
    DirectBill_UI.i nquiry.Page_Loa d(Object sender, EventArgs e) in c:\billing group\netsoluti ons\directbill\ directbill_ui\i nquiry.aspx.cs: 41
    System.Web.UI.C ontrol.OnLoad(E ventArgs e)
    System.Web.UI.C ontrol.LoadRecu rsive()
    System.Web.UI.P age.ProcessRequ estMain()


    ------------------------------------------------------ Version Information: Microsoft .NET Framework Version:1.1.432 2.2470; ASP.NET Version:1.1.432 2.2470
Working...