Download 48354880_WinAC_SQL_DB_Doc_V12_en
Transcript
6 Detailed Description of FBs 6.4 ODBC Block for Closing the Communication The last block in the step sequence is SQL_DISCON. It is responsible for the secure closing of the database. When a connection to an SQL database is no longer required, it must be closed again with this block. If the connection is not closed again, the established connections to the SQL server are not terminated. This may lead to errors such as Too Many Client Conenctions Active. It can also result in a buffer overflow, because several allocated storage areas are required for the connections, which are not properly closed without processing. SQL_DISCON should be called in any case. Figure 6-14 ODBC-CLOSE Block Copyright Siemens AG 2009 All rights reserved SQL_DISCON Prior to examining the syntactical part of the block, let us first look at the input and output parameters again: WinAC Link to an SQL Database V1.20, Entry-ID: 48354880 53