interbase, ibole.dll and visual basic

Posted on 2003-03-10
Medium Priority
Last Modified: 2013-12-09
I have the following problem with interbase:  
I program in visual basic, I connect myself with ibole.dll  
through of oledb, at the beginning when I believe the database  
the applications walk well but after a time  
notice in interbase manager that the number of attachments was increased  
when toward consultations and upgrades, this didn't happen  
before, this I number I end up passing the 500 attachments, and never  
made but of a connection to the database from visual basic.  
This generates that the applications you falied  
thank you

Para alguien que entienda español, tengo el  
siguiente problema con interbase:  
programo en visual basic, me conecto con ibole.dll  
atraves de oledb, al principio cuando creo la base de datos  
las aplicaciones andan bien pero despues de un tiempo  
note en interbase manager que el  "number of attachments" se incrementaba  
cuando hacia consultas y actualizaciones, esto no pasaba  
antes, este numero llego a pasar los 500 attachments, y en ningun  
memento hice mas de una conexion a la base de datos desde visual basic.  
Esto genera que las aplicaciones se cuelgen.  
Question by:juliohernan
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Accepted Solution

mor4eus earned 1000 total points
ID: 8149354
Sounds as if you aren't closing your connections properly in vb.  Are making sure you do a rs.close and ado.command =  nothing.

LVL 10

Expert Comment

ID: 9795398
Hi juliohernan,

if you got the needed answer, please accept it by clicking on Accept in the header of the good answer. By this way you can express thanks for expert's support

with best regards

LVL 10

Expert Comment

ID: 9830449

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:
       to accept mor4eus's answer
Please leave any comments here within the next seven days.


EE Cleanup Volunteer

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this article, we’ll look at how to deploy ProxySQL.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question