ODBC / Not Closing Connections

  • Posts: 271
  • Karma: 1
  • Thank you received: 5

ODBC / Not Closing Connections was created by Bozik

Hi,
i have small problem. I have a defined connection via odbc on DB2 db.

When I use this connection when importing as a "source" connection everything works perfect and the connection closes immediately after the query is completed.

But when I use this same connection when importing as a "target" connection will remain open even after the import is completed as an object. This connection is open until WimpEnt.exe run or agent job then it is closed.

Why is this happening?This causes problems on the firewall, which blocks than new connections.

Can you help me with that?!
Thx
Peter

Product: Visual Importer Enterprise & Active Table Editor
Repository: Microsoft SQL Server - 11.0.2100.60
Windows: Server 2012 Standart 64Bit
10 months 3 weeks ago #21156

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

  • Posts: 8458
  • Karma: 33
  • Thank you received: 567

Replied by admin on topic ODBC / Not Closing Connections

I had alook at the source code and I can confirm that our software disconnects from the target database once the import is completed.
It also disconnects after retrieving a list of fields and primary key information
I used Access ODBC as the target connection for testing.

we use SQLDisconnect() function
www.ibm.com/docs/en/db2-for-zos/11?topic...ect-from-data-source

Connecting to the server is a very heavy operation.
A lot of applications use connection pooling to speed things up.
Some of ODBC drivers allow the user to enable connection pooling as an advanced option.
That might be the issue in your case.
(I am just guessing here)
Mike
ETL Architect
10 months 3 weeks ago #21157

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

  • Posts: 1225
  • Karma: 3
  • Thank you received: 160

Replied by Peter.Jonson on topic ODBC / Not Closing Connections

Peter.

I can add some debug messages to exe, that might help to identify the problem.
What version do you have now?
Peter Jonson
ETL Developer
10 months 3 weeks ago #21158

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

  • Posts: 271
  • Karma: 1
  • Thank you received: 5

Replied by Bozik on topic ODBC / Not Closing Connections


Hi, it would be great! Our version is : 9.2.7.2
Peter

Product: Visual Importer Enterprise & Active Table Editor
Repository: Microsoft SQL Server - 11.0.2100.60
Windows: Server 2012 Standart 64Bit
10 months 3 weeks ago #21161

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

  • Posts: 271
  • Karma: 1
  • Thank you received: 5

Replied by Bozik on topic ODBC / Not Closing Connections

Hi Mike,

ok i check Connection pooling possibility with our type of ODBC connection (iSeries ODBC). I will inform you ..
Peter

Product: Visual Importer Enterprise & Active Table Editor
Repository: Microsoft SQL Server - 11.0.2100.60
Windows: Server 2012 Standart 64Bit
The following user(s) said Thank You: admin
10 months 3 weeks ago #21162

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

  • Posts: 8458
  • Karma: 33
  • Thank you received: 567

Replied by admin on topic ODBC / Not Closing Connections

How is it going?
Mike
ETL Architect
10 months 3 weeks ago #21177

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

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies