-
Forum
-
Main PGNP Forum
-
SQL Server/DTS/SSIS/Linked servers/Replication
-
Close connection with SSIS
Close connection with SSIS
-
changbai
-
Topic Author
-
Visitor
-
8 years 10 months ago #10912
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.
Less
More
-
Posts: 7
-
Thank you received: 0
-
-
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
-
8 years 10 months ago #10917
by changbai
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.
Less
More
-
Posts: 7
-
Thank you received: 0
-
-
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.
-
Forum
-
Main PGNP Forum
-
SQL Server/DTS/SSIS/Linked servers/Replication
-
Close connection with SSIS
Time to create page: 0.064 seconds
