Error Error "SQL state 60"

Hello Community,

I have a php application which opens a database connection. The code looks like this and is working fine.

$strDSN = "progress_test01";
$strUsername = "user";
$strPassword = "xyz";

$_SESSION [ 'odbc_connect_01' ] = odbc_connect( $strDSN, $strUsername, $strPassword )

$strSql = "SELECT
*
FROM PUB.V_BelegPos";

$result = odbc_connection_check( $strSql );

Code of the function:

function odbc_connection_check( $strSql )
{
if ( $result = odbc_prepare ( $_SESSION [ 'odbc_connect_01' ], $strSql ) )
{
$result = odbc_exec ( $_SESSION [ 'odbc_connect_01' ], $strSql );

return $result;
}
else
{
die("Error ".$strSql);
}
}

Up to this all the SQL statements are working fine.

Now i am opening a new PHP page via href.

On this page i want to open the connection again in order to execute a new SQL statement like the code above.
Now i got the following Error-Message
"odbc_connect(): SQL error: [unixODBC][DataDirect][ODBC 20101 driver]1201, SQL state 60 in SQLConnect in /home/user1002/www/htdocs/home/inc/datenbank_testumgebung.php on line 7, referer: http://test.precision-ptf.local/home/index.php?Link=lieferliste"

What does this message mean and what can i do?

We already tried to increment the connections to the database and tried to open another connection.
This both were not working.
 
Top