Yes, this is a good group. :)
The port requirement would depend on what you're connecting to on the AS400.
This tool may help you determine what ports AS400 is listening on.
http://support.microsoft.com/default.aspx?kbid=832919

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Fwed" wrote:
| Hi,
|
| I don't know if I am on the good group, sorry.
|
| I have the following thing :
|
| AS400 <--------- Firewall <----------- PC with client access & excel
|
| If I want to connect to the AS400 with excel (with ODBC) it does not work.
|
| If I remove the firewall, it work.
|
| I must open the port on the firewall but which one ?
|
| Thanks,
|
| Fwed