Forum Discussion

MarioGV's avatar
MarioGV
New Contributor III
1 year ago
Solved

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
    1 year 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
1 year ago

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

Henning's avatar
Henning
Icon for OneStream Employee rankOneStream Employee
1 year 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.