Close connection with SSIS

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

Close connection with SSIS

Postby changbai » Mon Mar 17, 2014 7:56 pm

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.
changbai
 
Posts: 2
Joined: Mon Mar 17, 2014 7:53 pm

Re: Close connection with SSIS

Postby Moderator » Wed Mar 19, 2014 9:39 pm

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!
User avatar
Moderator
Site Admin
 
Posts: 310
Joined: Wed Oct 29, 2008 11:27 pm

Re: Close connection with SSIS

Postby changbai » Thu Mar 20, 2014 7:34 pm

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
changbai
 
Posts: 2
Joined: Mon Mar 17, 2014 7:53 pm

Re: Close connection with SSIS

Postby Moderator » Sat Mar 22, 2014 1:20 pm

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}
User avatar
Moderator
Site Admin
 
Posts: 310
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 3 guests

cron