Dotaz: MSSQL_EXECUTE funkce

[N3Xt]

cafte. hladam po webe ale neviem co s tym... mam Linux a vedla na inom servry win a mssql 2000 na sql mam ulozenu proceduru s nazvom test v databazi s nazvom testt ako spustim tuto proceduru? kod je takyto:

$dbhost = "10.10.10.42:1433";
$dbuser = "sa";
$dbpass = "heslo";
$dbname="testt";

echo "Host: ".$dbhost."\n";
$dbsource = @mssql_connect($dbhost, $dbuser, $dbpass)
    or die("nemozem sa napojit");
$db = mssql_select_db($dbname, $dbsource)
    or die("nemozem zmenit databazu");
echo "
";

$myprocedure = mssql_init("test",$dbsource);
$spust = mssql_execute($myprocedure);
do {
    while ($row = mssql_fetch_row($spust)) {
        echo $row[1];
    }
} while (mssql_next_result($spust));
mssql_free_result($spust);
mssql_close($dbsource);

ale proste skoncim na tomto: Warning: mssql_execute() [function.mssql-execute]: stored procedure execution failed in /var/www/mssql/test.php on line 19 Warning: mssql_fetch_row(): supplied resource is not a valid MS SQL-result resource in /var/www/mssql/test.php on line 21 Warning: mssql_next_result(): supplied argument is not a valid MS SQL-result resource in /var/www/mssql/test.php on line 24 Warning: mssql_free_result(): supplied argument is not a valid MS SQL-result resource in /var/www/mssql/test.php on line 25

Odpovědi

[Robert Krátký]

Ahoj,

nevidím žádnou souvislost s Linuxem. Upřesni to prosím, nebo bude muset být dotaz vymazán, jelikož by nešel zařadit.

Díky.