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.External, "OneStream BI Blend")
Dim stringSQL As String= "SELECT Entity,UD1_01,UD1_02,UD1_03,UD1_04,UD1_05,UD1_06,UD1_07,UD1_08,UD1_09,UD1_10,UD1_11,UD1_12,UD1_13,UD1_14,UD1_15 from XFC_UD1sbyEnt where Entity = " & "'" & api.Pov.Entity.Name & "' ; "

dt  = BRapi.Database.ExecuteSql(dbConnApp, stringSQL.ToString, False)

but in the error message log have a lot of messages that I need to close the connection

Summary: Error in DbConnInfo.~DbConnInfo(). DbConnInfo should be used in a 'using' statement or Close() should be called explicitly.

 

does someone know how should be the command for close the connection?

 

Thanks in advance and best Regards.

Mario Guerrero

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
    12 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

  • MarioGV's avatar
    MarioGV
    New Contributor III
    12 days ago

    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.

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