Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Closing ADODC database connection

fluttyflutty Member Posts: 50
Hi all

I'm having an annoying problem with ADODC controls.

I am using them to bind Datagrids to a Access DB, but while the VB project is open (but not running) the database still has an active connection open.

I assume this is being caused by the fact that I am not closing the ADODC connection in my code, but I can't seem to find a way to do this.

I know I could avoid this using ADO objects, but I've had problems using them as the datasource for Datagrids, and got bored trying to resolve it.

ADODC works fine, apart from the fact that they don't seem to close their active connections when they go out of scope.

Any answers would be much appreciated.

Flut

Comments

  • btsebbtseb Member Posts: 67
    : Hi all
    :
    : I'm having an annoying problem with ADODC controls.
    :
    : I am using them to bind Datagrids to a Access DB, but while the VB project is open (but not running) the database still has an active connection open.
    :
    : I assume this is being caused by the fact that I am not closing the ADODC connection in my code, but I can't seem to find a way to do this.
    :
    : I know I could avoid this using ADO objects, but I've had problems using them as the datasource for Datagrids, and got bored trying to resolve it.
    :

    : ADODC works fine, apart from the fact that they don't seem to close their active connections when they go out of scope.
    :
    : Any answers would be much appreciated.
    :
    : Flut
    :


    ****************************************
    All you need to do is :

    [red](Your ADOC Connection name).Close[/red]

Sign In or Register to comment.