mssql.dll vs. sybase_ct

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux