RE: Connecting using Microsoft OLE DB Provider for DB2 (AS/400 TCP

From: Jim Jacobson (JimJacobson_at_nospam.nospam)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 11:29:01 -0700

I am not trying to link to DB2/AS400 as a linked server, I am trying to
transfer data back and forth using DTS packages, but the problem would exist
in either case.

I have installed the Data Access part of Host Integration Server 2000a on
the machine in question so that I might use the OLE DB Provider for DB2 that
comes with it. I already have the latest service pack (1) for that installed.

There is no firewall between the two machines. I know the port I have used
is correct because I can connect to the AS/400 database using an OLE DB
provider from another vendor, which is configured with the same IP address
and port. I also get a different result on the port I have configured (port
8471, which yields a SQLCODE of -576) than any other port I try (which yields
a SQLCODE of -603). Do you get an SQLCODE of -576 when you change the port
to an invalid one?

To reiterate, the AS/400 is configured to use port 8471, not 446 (the
standard port).

I have investigated the links you provided, but there is nothing there that
furthered my ability to connect.

-Jim Jacobson

""Mingqing Cheng [MSFT]"" wrote:

> Hi Jim,
>
> Thanks for using MSDN Newsgroup!
>
> Based on my understanding, you encounter error message SQLSTATE: 08S01,
> SQLCODE: -576 when trying linking DB2/AS400 in SQL Server as Linked Server.
> Have I understood you? If there is anything I misunderstood, please feel
> free to let me know.
>
> If you are using Host Integration Server 2000, please make the latest
> update according to the following documents
>
> FIX: Host Integration Server ODBC Driver for DB2 Causes Jet Error With
> Special Characters in Table Names
> http://support.microsoft.com/?id=325068
>
> Secondly, I found we could reproduce the same error if we put port 449,
> checking whether your Firewall has open the to 446.
>
> Additonaly, the following documents may be helpful to you.
>
> INF: Creating a Linked Server to DB2 using Microsoft OLE DB Provider for DB2
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q222937
>
> OLEDB Provider Error Message: The Conversation Was Deallocated with AP_ABEND
> http://support.microsoft.com/?id=300685
>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
>
> Sincerely yours,
>
> Mingqing Cheng
> Microsoft Developer Community Support
> ---------------------------------------------------------------
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>

Relevant Pages

  • Serial port Rx queue size
    ... WinCE uses ReadFile/WriteFile internal buffers to transfer data and no ... because it grows when I send more data to the port and I don't call ... WriteFile to return depands on the serial port connection speed (and ...
    (microsoft.public.windowsce.embedded)
  • Re: serial driver
    ... port i.e. COM1 through my emulator and transfer data at some predefined baud ... USB device driver will monitor the slot in the sense that it will know if ... with your previous serial port/baud rate question? ... port settings. ...
    (microsoft.public.windowsce.app.development)
  • Re: Using XMD for memory dumps (speed)
    ... Currently I am considering using the serial port to transfer data back ... I'd suggest you try using a download TCL script from within XMD. ... communication and remote protocol overhead between XMD and GDB. ...
    (comp.arch.fpga)
  • Question on network programming.
    ... I am trying to build a system to let user transfer data and chat using ... So it is correct to use 3 IdTCPClient and IdTCPServer: ... IP and only one port??? ...
    (comp.lang.pascal.delphi.misc)
Quantcast