Re: Linked Server - DB2 - iseries
- From: <msnews.microsoft.com>
- Date: Wed, 13 Jul 2005 12:07:54 +0800
The error came from the DB2 OLEDB provider. You may contact IBM for
assitance.
- billyy
"Denny" <denny@xxxxxxxx> дÈëÓʼþ
news:eEVD1RKYFHA.3132@xxxxxxxxxxxxxxxxxxxxxxx
>
>
> I am trying to set up a linked server to our iseries through Enterprise
> Manager and am getting the message;
>
> Error 7304; Could not create new session on OLE DB Provider 'IBMDA400'
> OLE DB error trace [OLD/DB provider 'IBMDA400' IDBCreatesession:: returned
> 0x80040e44].
>
> I am using the following in the Linked Server Properties;
>
> Provider name: IBM DB2 UDB for iseries OLE DB Provider
> PRoduct name: Microsoft OLE DB Provider for DB2
> Data Source: AS400.domainname.com (the
domain
> name of our as400 server)
> Catalog: libname
> (the Library name on the AS400)
>
>
> I am using remote login using my AS400 userid in CAPS and password (using
> Security context)
> Server options has Data Access and User Remote Collation checked.
>
>
>
.
- Prev by Date: Re: SQL 2000 Server odbc connection broken after 10-20 minutes
- Next by Date: Re: CAN CONNECT ONE WAY TO SQL SERVER BUT NOT BACK
- Previous by thread: Re: SQL 2000 Server odbc connection broken after 10-20 minutes
- Next by thread: Re: CAN CONNECT ONE WAY TO SQL SERVER BUT NOT BACK
- Index(es):
Relevant Pages
|
