|
Home > Archive > MS SQL Server > October 2006 > Linked server (DB2)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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;NetAdd
r=10.10.10. 10;NetPort=1234;nitC
at=DB2T;Default
Schema=admin;PkgCol=
admin;IsoLvl=NC;CCSI
D=37;PCCodePage=1252
;BinAsChar=NO;Data
Source=DB2T'
Thank you !
| |
| John Bell 2006-10-24, 6:33 pm |
| 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;NetAdd
r=10.10.10. 10;NetPort=1234;nitC
at=DB2T;Default
> Schema=admin;PkgCol=
admin;IsoLvl=NC;CCSI
D=37;PCCodePage=1252
;BinAsChar=NO;Data
> Source=DB2T'
>
> Thank you !
>
>
|
|
|
|
|