cannot open DB connection PGNP 1.4

More
8 months 19 hours ago #14670 by olla
Hello,

We are using Intellisoft OLE DB Provider for PostgreSQL and we often see this error: 0x80004005 Cannot open DB connection.

Many people here think it can be caused by a network timeout. So i try to run ICMP ping to the destination and while this error appear, there is 0% packetloss to the destination. Also i think the timeout expire is around 15sec. 
We also try to check the logs at postgresql side, but there is nothing related to this connection.

Sometimes it works, and sometimes it don't.

Please see attached the error.

If you have any idea what it could be / how to diagnose ill be happy to know it.

Thanks you,
Attachments:

Please Log in or Create an account to join the conversation.

More
8 months 13 hours ago #14671 by admin
Hello,
please collect trace in PGNProfiler while connection is made. The trace will contain detailed reason on why connection cannot be made (missing password, timeout, connection refused, etc.).
In case there is a timeout issue, please specify "Connection Timeout" in the SSIS Connection Manager.

Feel free to email the trace and additional info to our Support.

HTH

Please Log in or Create an account to join the conversation.

More
8 months 13 hours ago #14672 by olla
Hello, thanks you very much for this quick answer.

Could you tell me how to start a capture with PGNProfiler? not sure to know how to use it..

thanks you

Please Log in or Create an account to join the conversation.

More
8 months 13 hours ago #14673 by admin
Launch PGNProfiler utility from Start->Intellisoft OLEDB Provider menu, or from folder C:\Program Files (x86)\Intellisoft\PGNP. Then click triangle button in Toolbar to start capture. If capturing trace from linked server, then launch PGNProfiler as Administrator. Additional info can be found in the Develeoper's Manual (available from Download page).
The following user(s) said Thank You: olla

Please Log in or Create an account to join the conversation.

More
8 months 12 hours ago #14674 by olla
We will try this !

Thanks you very much

Please Log in or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum