473,394 Members | 1,841 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

ADODC closing connection

2
I have an ADODC object in my form which populates a datagrid.

I set the coonection string for ADODC at design time.

The problem is that I have no way to close the connection when i exit the application.

The lock file which the connection creates persists even after I exit.

This is what I write in form_unload:

Set Adodc1.Recordset = Nothing
Adodc1.ConnectionString = ""
Jun 28 '06 #1
1 8470
This may have been overlooked in your post but did you close the recordset and the connection before setting to nothing, ie;
Adodc1.recordset.close
set adodc1.recordset = nothing
adodc1.close (if adodc1 is your connection object)
set adodc1 = nothing

Al


I have an ADODC object in my form which populates a datagrid.

I set the coonection string for ADODC at design time.

The problem is that I have no way to close the connection when i exit the application.

The lock file which the connection creates persists even after I exit.

This is what I write in form_unload:

Set Adodc1.Recordset = Nothing
Adodc1.ConnectionString = ""
Jun 28 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Tumurbaatar S. | last post by:
Is it so important to close database connections? As I understand, after processing a request and sending a response, page object destroyed. So all used connections also destroyed. Yes?
4
by: Raoul Watson | last post by:
I have a form with an AdoDc control associated to a datagrid. The AdoDC uses a "ConnectionString" such as "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=..." this is...
1
by: pramodrepaka | last post by:
Hello Guys Plz Help me Here is my problem . Unable to retriew the data beteen oracle and vb by using ADODC control i.e if a table consists of Nll values. i am created table...
9
by: Neelesh2007 | last post by:
Hi All, I have developed project in VB6.0 with access as backend.I have used ADODC control in VB to retrieve data from access. I have created the Setup file by Package & Deployment. Now when i...
4
by: jaz215 | last post by:
hi! how do i add a record in a database without using the datacontrol and adodc. i want to rework my code to using purely codes and not being dependent on the design on vb. so far i have. Set rs...
1
by: hussainiyad | last post by:
Dear all, i,m new to v.b and i tried to connect to sqlserver through adodc in a datagrid or datalist , but there was no result in my form, can any one tell me what's the reason and i done every...
6
by: hussainiyad | last post by:
Hi all, I,m new to vb.6.0 and i don,t know how to connect to sql server through v.b 6.0 with the help of adodc control, and anyone plz tell me how connect and insert ,update,delete and other...
2
by: talktorafique | last post by:
i am unable to find the coding of "find" in adodc database-----acess software------vb6.0 provider-------microsoft jet 4.0 OLEDB provider connection---adodc coding: adodc1.recordset.find()
0
by: guruthe13 | last post by:
Hi Folks, I m trying to link adodc Control with the Oracle 8i, as I just a starter in this program and m trying learning new things.When I try ti use connection string and select the build button,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.