|
I have a database on a MS SQL Server (SP3a), installed on a Windows XP Pro
(SP2) testbed. I think that I've got the DRDA stuff set up properly on the
AS400:
1. ADDTCPHTE INTNETADR('192.168.30.66') HOSTNAME((TOMDELL))
2. QSYS/ADDRDBDIRE RDB('TOMDELL') RMTLOCNAME('192.168.30.66' *IP)
3. ADDSVRAUTE USRPRF(TOMH) SERVER(TOMDELL) USRID(TOMH) PASSWORD('PASSWORD')
I start up Interactive SQL on the 400, and enter this command:
connect to TOMDELL user tomh using 'PASSWORD'
And I get this error log:
>strsql
>A remote host refused an attempted connect operation (CPE3425)
>DDM TCP/IP communications error occurred on connect() to Application Server
>(CPD3E34)
>File QCNDDMF was already closed, never opened or not from this process
>(CPF4404)
>Cannot establish DDM connection with remote system (CPF9162)
>Communication error occurred during distributed database processing
>(SQ30080)
I'm weak on the PC side of things - to allow the connection to the pc
database:
1. I've "heard" DRDA is available for MS SQL Server - true? How do I
get/activate it? Or is it already active after initial MS SQL Server
installation?
2. Is there some config that I need to check in MS SQL Server 2000? How
about in Windows XP Pro?
3. There's no firewall running on the PC, there is a corporate firewall. Do
I need to make sure that some particular ports are open?
4. Is there some .net or other PC software thing that I should install to
get this working?
Tom
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.