Linked server (DB2)

Hello,
I'm trying to create a linked server for the last week and it's still
not working. I'm using "Microsoft OLE DB Provider for DB2". Here is the
error that i have:
Msg 64, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the
server. (provider: TCP Provider, error: 0 - The specified network name
is no longer available.)
And here is the provider string that i use:
EXEC sp_addlinkedserver @.server = 'DB2SRV',
@.srvproduct = 'Microsoft OLE DB Provider for DB2',
@.catalog = 'DB2T',
@.provider = 'DB2OLEDB',
@.provstr =
'NetLib=TCPIP;NetAddr=10.10.10.10;NetPort=1234;nitCat=DB2T;Default
Schema=admin;PkgCol=admin;IsoLvl=NC;CCSI
D=37;PCCodePage=1252;BinAsChar=NO;Da
ta
Source=DB2T'
Thank you !Hi Mike
I have never use this provider, but I have noticed that you have nitCat in
the connection string instead of InitCat.
John
"Mike" wrote:

> Hello,
> I'm trying to create a linked server for the last week and it's still
> not working. I'm using "Microsoft OLE DB Provider for DB2". Here is the
> error that i have:
> Msg 64, Level 20, State 0, Line 0
> A transport-level error has occurred when receiving results from the
> server. (provider: TCP Provider, error: 0 - The specified network name
> is no longer available.)
> And here is the provider string that i use:
> EXEC sp_addlinkedserver @.server = 'DB2SRV',
> @.srvproduct = 'Microsoft OLE DB Provider for DB2',
> @.catalog = 'DB2T',
> @.provider = 'DB2OLEDB',
> @.provstr =
> 'NetLib=TCPIP;NetAddr=10.10.10.10;NetPort=1234;nitCat=DB2T;Default
> Schema=admin;PkgCol=admin;IsoLvl=NC;CCSI
D=37;PCCodePage=1252;BinAsChar=NO;
Data
> Source=DB2T'
> Thank you !
>