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.

MarioGV's avatar
MarioGV
New Contributor III

Hi Daniel, it suppose to close the connection, but in the error log shows more than 100 pages with the same error message and it's difficult to track other messages. when I found the solution will let you know.

Thank you for your comment. Regards.

Mario Guerrero

DanielWillis's avatar
DanielWillis
Valued Contributor
11 days ago

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.