Close connection with SSIS

  • changbai
  • Topic Author
  • Visitor
  • Visitor
8 years 10 months ago #10912 by changbai
Close connection with SSIS was created by changbai
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
( 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
8 years 10 months ago #10915 by Moderator
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.

  • changbai
  • Topic Author
  • Visitor
  • Visitor
8 years 10 months ago #10917 by changbai
Replied by changbai on 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
8 years 10 months ago #10919 by Moderator
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.064 seconds
Powered by Kunena Forum