Hi,
We are trying to move some php webapplications from windows to linux.
One of them is one with necessery db-connection to an MSSQL server.
The application migration isn't running too smooth, since:
If I udnerstand it correctly, there is the native-mssql connector for
PHP under windows, the mssql.dll, and under unix/linux there is the
php_sybase_ct.so, linked to the freetds libraries.
Can this mean, that the used mssql_ functions used from the mssql.dll
can cause a bit challange to port the application to linux and
php-sybase_ct?
We keep getting errormsgs like:
Warning: mssql_num_rows(): supplied argument is not a valid Sybase result resource in
/opt/appdata/web/apache2/tbinfo.utalan.at/public_html/content/page01.php on line 5
atsrvlx02-new:/opt/appdata/web/apache2/tbinfo.utalan.at/public_html/content#
grep -A5 -B5 mssql_num_rows
/opt/appdata/web/apache2/tbinfo.utalan.at/public_html/content/page01.php
<?php
include("../bwuser/config.php");
$result_online = mssql_query("SELECT * FROM WEBSEC_T05_ONLINE");
$number_online = mssql_num_rows($result_online);
if ($number_online == 0){$onlinetxt= "Online Info";}
else {$onlinetxt= $number_online." Member online";}
?>
<!doctype html public "-//W3C//DTD HTML 4.0 Transitional//EN">
atsrvlx02-new:/opt/appdata/web/apache2/tbinfo.utalan.at/public_html/content#
okay, If I try it with another sql client, it say 0 rows selected.
Another question: Can I use the mssql.dll in a form like mssql.so under
linux/unix? As I see for this I have to recompile my php4.
Is there any reason that the PHP FAQ suggests the sybase_ct.so module
and not the mssql.so module?
In my (debian) distribution I didnt even find the mssql.so php module.
Is that some licence issue? Or does it have disadvantages?
any help/info is appreciated.
tia
charlie
--
- Because it messes up the order in which you normally read text.
- Why is top-posting such a bad idea?
- Top-posting.
- What is the most annoying thing on Usenet?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
