Close connection with SSIS

More
6 years 2 months ago #10912 by changbai
changbai created the topic: Close connection with SSIS
Hi

Im using pgnp 1.4.0 version.

When the transaction is completed,
the connection is remained with IDLE status.

In forum I found that the same issue was fixed
( http://www.pgoledb.com/forum/viewtopic? ... connection ).
How can I close the connection
when the transaction is committed?

Thanks.

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

More
6 years 2 months ago #10915 by Moderator
Moderator replied the topic: Re: Close connection with SSIS
This could be related to the default OLEDB connection pooling. Please check that the connection gets closed after 2 minutes. If connection is closed after the timeout and you want to disable the behavior, configure OLEDB_SERVICES registry key to disable the pooling.

If connection never closes, it could be a bug. Please e-mail us details on how to reproduce the issue.

Thank you!

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

More
6 years 2 months ago #10917 by changbai
changbai replied the topic: Re: Close connection with SSIS
Thank you for reply.

But I could not find pooling information about OLEDB_SERVICES key in reg editor.

Show me the full key name or other place to set for pooling.

Regards,
Changbai

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

More
6 years 2 months ago #10919 by Moderator
Moderator replied the topic: Re: Close connection with SSIS
For Postgres and Greenplum providers (PGNP): HKEY_CLASSES_ROOT\CLSID\{3170DFF1-4803-42a0-A1B3-D14656857071}

For Redshift provider (RSNP): HKEY_CLASSES_ROOT\CLSID\{FFCCB099-E3D0-4FFC-87F9-AC3FAAF91271}

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

Time to create page: 0.088 seconds
Powered by Kunena Forum