Close connection with SSIS
- changbai
- Topic Author
- 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.
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.
8 years 10 months ago #10915
by Moderator
Replied by Moderator on 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!
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
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
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.
8 years 10 months ago #10919
by Moderator
Replied by Moderator on 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}
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
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
SQL Server/DTS/SSIS/Linked servers/Replication
- Close connection with SSIS