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 thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.