Connect DB2 from MS-Excel

2445 pts.
Tags:
AS/400
DB2 connectivity
Microsoft Access
Hi all! I'm trying to connect the AS/400 DB2 from MS-Excel but I'm Getting Communication link failure .comm rc=10061 - CWBO1049 - The IBM i server application is not started or the connection was blocked by a firewall. I have tried STRTCPSVR *ALL STRHOSTSVR *ALL and PING from PC to SERVER is ok. and from SERVER to PC is ok. then CWBPING is showing the same error message for CWBO1049. Surey.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta

    You say you ran STRTCPSVR and STRHOSTSVR, but did you check to see if the appropriate server actually started?

    If the server started and is accepting connections, and a valid route exists but CWBPING fails, then you either have a server that didn't start or have a firewall blocking the server port. The firewall might be software at either the PC or the server system or hardware anywhere along the route.

    Tom

    125,585 pointsBadges:
    report
  • Sureyz
    Tom
    Can you tell me how can i check whether a server has already started or not?
    2,445 pointsBadges:
    report
  • TomLiotta
    If possible, iSeries Navigator should be used to see if a server reports as 'Started' or not. Otherwise, the Server table in your system's version of the Information Center lists job names for the different servers. You can look at jobs to see if the appropriate job is running and lokk at joblogs to see if problems are reported. (But you should use iSeries Navigator.) -- Tom
    125,585 pointsBadges:
    report
  • Sureyz
    what are the other main servers should be started for this solution.
    Because i have already started the FTP server TELNET server.
    Also i'm unable to start the database and file server which is in i Series Navigator -> Network -> Servers -> System i Access.


    Surey.
    2,445 pointsBadges:
    report
  • TomLiotta

    FTP and telnet are unrelated to this problem.

    Also i’m unable to start the database and file server which is in i Series Navigator -> Network -> Servers -> System i Access.

    Why? What happens?

    The Database server is the one most likely needed for this problem, but others might be needed for iSeries Navigator. Also, depending on your ODBC driver, the Database server might not be the right one to start. If you right-click on the Database server, you can select to see the Database server jobs. When you right-click on a job, you can select to see its joblog. By scanning through joblogs, you should be able to see why the server jobs won't start properly for you.

    Tom

    125,585 pointsBadges:
    report
  • Sureyz
    Tom
    In the database server system log showing the job name QZDASOINIT for user QSECOFR is waiting for time interval. I guess this is the problem because others are ok.. what can be done here ?

    2,445 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following