Advertisement

03.19.2008 at 11:32AM PDT, ID: 23254680
[x]
Attachment Details

Linked Server connection to DB2 Connects and drops all the time now

Asked by Paul_Schroeder in DB2 Database, MS SQL DTS

I began getting this msg a couple weeks ago and I don't know what is causing it.  Sometimes it is the DB2 account is locked but it is only being used for the linked server connection.  What can we do to fix?
Here is the error msg from my DTS Log.

Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:OLE DB provider 'MSDASQL' reported an error.   (Microsoft OLE DB Provider for SQL Server (80040e14): OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005:   ].) (Microsoft OLE DB Provider for SQL Server (80040e14): [OLE/DB provider returned message: [IBM][CLI Driver] SQL30082N  Attempt to establish connection failed with security reason "15" ("PROCESSING FAILURE").  SQLSTATE=08001
]) (Microsoft OLE DB Provider for SQL Server (80040e14): [OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed]) (Microsoft OLE DB Provider for SQL Server (80040e14): [OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed]) (Microsoft OLE DB Provider for SQL Server (80040e14): [OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed])
Step Error code: 80040E14Start Free Trial
[+][-]03.19.2008 at 08:04PM PDT, ID: 21167947

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.20.2008 at 12:06AM PDT, ID: 21168820

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.20.2008 at 05:27AM PDT, ID: 21170499

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.20.2008 at 05:52AM PDT, ID: 21170727

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.20.2008 at 05:54AM PDT, ID: 21170752

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.27.2008 at 07:06AM PDT, ID: 21221439

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: DB2 Database, MS SQL DTS
Sign Up Now!
Solution Provided By: ghp7000
Participating Experts: 3
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628