Forum Discussion

MarioGV's avatar
MarioGV
New Contributor III
21 days ago

how can I close a database connection

cHi All, good day.   I'm using a database connection and it's working good: Dim dt As DataTable = Nothing Dim dbConnApp As DbConnInfo = BRApi.Database.CreateDbConnInfo(_si, Dblocation.Externa...
Finance
  • MarioGV's avatar
    MarioGV
    21 days ago

    hi All, after several tests and SQL readings, I found the solution, at the end it need to add a line:

                dbConnApp.Close()

    The database connection has closed and no error message.

    I hope it could help somebody. Regards.

DanielWillis's avatar
DanielWillis
Valued Contributor
21 days ago

Hi Mario

The Snippets panel has a lot of information for things like this. The error message is pointing you to the Using statement which automatically closes the connection when done.

Regards,

Daniel