DB2 Connect Error in .NET FrameWork 2.0 Application

Shyam Kompalli

DB2 Connect Error in .NET FrameWork 2.0 Application

Folks

We have an .NET application running on Windows 2003 Server. I have
installed DB2 Connect V8.2 EE and also DB2 Connect Run Time Client V9.0
on top of it to support .NET FrameWork 2.0.

The application was running fine in the past. I don't know what changed
on the server but now I am getting SQL1159 Reason Code 2 for DB2APP.DLL
file. I checked the description for error and its says "File Not Found"

I asked the programmer to do a trace on .NET Application. I am pasting a
portion of the trace below. Look at the extra / in the path

I know why its failing with SQL 1159 but I can't figure out where its
picking up the extra / in the path

I checked all the environment variables and did a search on the registry
entries for // and db2app.dll

I have installed DB2 Connect EE V8.2 in F:/Program Files/IBM/SQLLIB and
Run Time Client V9.0 in F:/Program Files /IBM/SQLLIB_01

Appreciate if someone can help.

faultcode>soap:Client</faultcode>
<faultstring>System.Web.Services.Protocols.SoapException: Unrecoverable
Fault Occurred - See Details Node for inner exception --->
NCC.CommonServices.Shared.ExceptionHandling.UnrecoverableCommonServicesE
xception: 1000||Exception in CustomerBL: The type initializer for
'IBM.Data.DB2.DB2Connection' threw an exception. --->
System.TypeInitializationException: The type initializer for
'IBM.Data.DB2.DB2Connection' threw an exception. --->
System.InvalidOperationException: SQL1159 Initialization error with DB2
.NET Data Provider, reason code 2, tokens F:\Program
Files\IBM\SQLLIB_01\\bin\db2app.dll, at IBM.Data.DB2.y.f.a() at
IBM.Data.DB2.DB2ConnPool.g() at IBM.Data.DB2.DB2ConnPool..ctor() at
IBM.Data.DB2.DB2Connection..cctor() --- End of inner exception stack
trace --- at IBM.Data.DB2.DB2Connection..ctor(String connectionString)
at
NCC.CommonServices.Customer.Service.DataAccess.Db2Dal.RetrieveDataTable(
String query) at
NCC.CommonServices.Customer.Library.DataAccess.CustomerDal.RetrievePrici
ngRelationship(String ipId, String periodEndDate) at
NCC.CommonServices.Customer.Service.BusinessLogic.CustomerBL.RetrievePri
cingRelationship(PersistentCustomerIdType pcidToRetrieve) --- End of
inner exception stack trace --- at
NCC.CommonServices.Customer.Service.BusinessFacade.CustomerBF.RetrievePr
icingRelationship(RetrievePricingRelationshipRequest request) at
NCC.CommonServices.Customer.Service.CustomerService.RetrievePricingRelat
ionshipImpl(RetrievePricingRelationshipRequest request) --- End of inner
exception stack trace --- at
NCC.CommonServices.Customer.Service.BaseClasses.BaseSI.LogException(Comm
onServicesException cse, String transactionName) at
NCC.CommonServices.Customer.Service.CustomerService.RetrievePricingRelat
ionshipImpl(RetrievePricingRelationshipRequest request) at
NCC.CommonServices.Customer.Service.CustomerService.RetrievePricingRelat
ionship(RetrievePricingRelationshipRequest request)</faultstring>
<faultactor>http://ohcleiis4337.corpdev.ntl-city.net/NCC.CommonServices.
Customer.Service/Service/CustomerService.asmx</faultactor>
- <\l > <detail>
- <\l > <unrecoverableCommonServicesException>
<message>1000||Exception in CustomerBL: The type initializer for
'IBM.Data.DB2.DB2Connection' threw an exception.</message>
<isExceptionLogged>True</isExceptionLogged>
- <\l > <innerException>




-------------------------------------------------------------------------------------------
***National City made the following annotations
-------------------------------------------------------------------------------------------
This communication is a confidential and proprietary business communication.
It is intended solely for the use of the designated recipient(s). If this
communication is received in error, please contact the sender and delete
this communication.
===================

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