Forum Discussion

MarioGV's avatar
MarioGV
New Contributor III
12 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
    12 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

I think you might be doing something wrong. Using 'Using' is standard practise. Feel free to share your code.

Henning's avatar
Henning
Valued Contributor II
11 days ago

I would also recommended to follow standard practice on that and try to use the "Using" statement as e.g. per snippet Daniel shared earlier.