Skip to main content

How to check database connection

  • December 9, 2013
  • 2 replies
  • 0 views
D

Hi,

I'm connecting to our SQL Server database from multiple programs. I would like to check at the beginning of each program, if a connection to the SQL Server is already established (by a previously executed program in the same chain). If it is not, I would then like to connect to the database.

Now, I could basically execute some basic SELECT statement and if the return code isn't zero, then it means the connection isn't established. But is there a specific statement in SQL or COBOL, with which I could check the status of the connection?

Cheers,

Raffi

    2 replies

    Chris Glazier
    Forum|alt.badge.img+3

    Hi,

    I'm connecting to our SQL Server database from multiple programs. I would like to check at the beginning of each program, if a connection to the SQL Server is already established (by a previously executed program in the same chain). If it is not, I would then like to connect to the database.

    Now, I could basically execute some basic SELECT statement and if the return code isn't zero, then it means the connection isn't established. But is there a specific statement in SQL or COBOL, with which I could check the status of the connection?

    Cheers,

    Raffi

    If you are sharing the same connection between multiple programs within a run-unit then you should be using a named connection:

          EXEC SQL

            CONNECT TO 'SQLODBC32' as connect1

          END-EXEC.

    When you try to connect to a named connection that is already open you will receive a sqlcode -19707 with message "Duplicate Connection Name".

    So if prog2 tries to connect and the connection has not yet been made it will succeed and you will get a sqlcode = 0. If prog2 tries to connect but prog1 already has made the connection you will receive a sqlcode -19707.

    Either way you will have a valid connection that prog2 can use.

    Thanks.

    D

    Hi,

    I'm connecting to our SQL Server database from multiple programs. I would like to check at the beginning of each program, if a connection to the SQL Server is already established (by a previously executed program in the same chain). If it is not, I would then like to connect to the database.

    Now, I could basically execute some basic SELECT statement and if the return code isn't zero, then it means the connection isn't established. But is there a specific statement in SQL or COBOL, with which I could check the status of the connection?

    Cheers,

    Raffi

    Worked like a charm, thank you!

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement