Published on Linux Journal (http://www.linuxjournal.com)
What is the error in php?
By ymengel
Created 2008-03-03 04:06

In this php program:

<?php
// connect to DSN MSSQL with a user and password
$connect = odbc_connect("DSNNAME", "miki", "84139") or die ("couldn't connect");
ini_set('odbc.defaultrl','65536');
odbc_exec($connect, "use SwitchCenterDB");
$result = odbc_exec($connect, 'show tables');
while(odbc_fetch_row($result)){
...
}
odbc_free_result($result);
odbc_close($connect);
?>[Mon Mar 03 11:49:59 2008] [error] [client 132.64.4.16] PHP Warning: odbc_exec() [function.odbc-exec [1]]: SQL error: [unixODBC][FreeTDS][SQL Server]Could not find stored procedure 'show'., SQL state 37000 in SQLExecDirect in /srv/www/htdocs/hu/Proj1/ttc.php on line ...

there is an error:

__________________________

‹ php script --> MSSQL error. Why? See details below [2] What is the error in getting an info from MSSQL? Enclosed herewith: an error message and source of the program › [3]
Source URL: http://www.linuxjournal.com/content/what-error-php

Links:
[1] http://www.linuxjournal.com/function.odbc-exec
[2] http://www.linuxjournal.com/content/php-script-mssql-error-why-see-details-below
[3] http://www.linuxjournal.com/content/what-error-getting-info-mssql-enclosed-herewith-error-message-and-source-program