Article ID: 246706
Article Last Modified on 3/12/2004
APPLIES TO
- Microsoft SNA Server 4.0 Service Pack 3
- Microsoft SNA Server 4.0 Service Pack 2
- Microsoft Host Integration Server 2000 Standard Edition
- Microsoft Host Integration Server 2000 Service Pack 1
This article was previously published under Q246706
SYMPTOMS
If the TCP/IP DDM Server on the AS/400 is not started, the following data providers cannot connect over TCP/IP:
- Microsoft OLE DB Provider for AS/400
- VSAMMicrosoft OLE DB Provider for DB2Microsoft ODBC Driver for DB2
If the TCP/IP DDM Server on the AS/400 is not started, testing the connection for the data providers that are listed earlier will return the following error messages:
- For Microsoft OLE DB Provider for AS/400 and VSAM:
- For Microsoft OLE DB Provider for DB2:
- For Microsoft ODBC Driver for DB2:
Following are other potential causes for TCP/IP related errors (SQLCODE: -603 and -602):
- The IP address (or name) is incorrect.
- The IP port is incorrect.
RESOLUTION
Verify status of TCP/IP DDM Server on the AS/400 by performing the following steps:
- From an AS/400 command line, type the following command:
netstat
When the following menu appears, choose option number 3 (Work with TCP/IP connection status):
1. Work with TCP/IP interface status 2. Display TCP/IP route information 3. Work with TCP/IP connection status
A list that is similar to the following will be displayed:
Remote Remote Local Opt Address Port Port Idle Time State __ * * drda 001:13:15 Listen __ * * ddm 001:13:15 Listen __ * * ddm-ssl 001:13:15 Listen
The list should contain an entry with the Local Port listed as drda. Scroll through the list until this entry is located. If this entry is not present, the TCP/IP DDM Server has not been started.
- To start the TCP/IP DDM Server, type the following command from an AS/400 command line:
strtcpsvr server(*ddm)
- Repeat steps 1 through 3 above to verify that the server has started properly.
It is also possible to automatically start the DDM server whenever TCP/IP is started on the AS/400 system. Issue the following command on an AS/400 command line to enable this functionality:
chgddmtcpa autostart(*yes)
MORE INFORMATION
For more information about using the commands that are mentioned eariler in this article, refer to the IBM OS/400 CL Reference V4R4 (Document Number SC41-5722-03).
Microsoft has updated Host Integration Server 2000 OLE DB Provider for DB2 and ODBC Driver for DB2 to provide specific SOCKET_ERROR messages. The messages are seen in DB2 Network Library internal tracing, specifically when Error Conditions is turned on.
To enable tracing, you use the Systems Network Architecture (SNA) Trace utility (Snatrace.exe). You might receive error messages when you connect, send, or receive over the Windows TCP socket. Following is an example format of a trace message:
For additional information about the enhancement, click the following article number to view the article in the Microsoft Knowledge Base:
329818 Vague TCP/IP Socket Errors Are Returned for OLE DB2 Provider
The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
Additional query words: HIS 2000
Keywords: KB246706