Excel, client access & AS400
 

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

Excel, client access & AS400
 

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

Excel, client access & AS400
 

Thank you for your answer :)

I will test the port scanner to find what destination port is used by
the windows :)

Dave Patrick a écrit :
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

Excel, client access & AS400
 

You're welcome but the port isn't determined by windows in this case. It is
determined by the process running on AS400 What driver are you using to
connect?

--

Regards,

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

"Fwed" wrote:
Thank you for your answer :)

I will test the port scanner to find what destination port is used by
the windows :)

Excel, client access & AS400
 

I don't know ... in fact, it's a customer who have this problem, and I
do configure the firewall ... So i don't know anything about as400, odbc
and excel ... But without firewall, that work. With your tool, i will
find the good destination port and open it on the firewall :)

Your tool seem to be better that netstat :)

Thank you a lot :)

Dave Patrick a écrit :
You're welcome but the port isn't determined by windows in this case. It is
determined by the process running on AS400 What driver are you using to
connect?

Excel, client access & AS400
 

OK, hope it helps.

--

Regards,

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

"Fwed" wrote:
I don't know ... in fact, it's a customer who have this problem, and I
do configure the firewall ... So i don't know anything about as400, odbc
and excel ... But without firewall, that work. With your tool, i will
find the good destination port and open it on the firewall :)

Your tool seem to be better that netstat :)

Thank you a lot :)