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
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