Le Wednesday 21 January 2004, 12:54:18 ou environ Robert Twitty <rtwitty@xxxxxxxxxxxxxxxxx> a écrit: Hi again Bob, It was about 13h00 (13 pm) when you sent this mail and about 8 pm here. Thus give me time to go back to work tomorrow morning and to study the question. If interested I contact again. Good Night, Alain > Hi Alain > > ODBTP is a protocol that provides remote access to WIn32-based ODBC > drivers. More details are available at http://odbtp.sourceforge.net. I > created it because PHP's mssql ext did not adequately support SQL Server > 7.0 and 2000. The main problem with this ext is that on UNIX it was built > with FreeTDS, a reengineered and sometimes faulty version of the TDS > protocol. On Windows it was built with the obsolete and unsupported > DB-Library, which does not support ntext or varchar(>255) data types. > > ODBTP provides the best access to MSSQL because it uses the ODBC driver > for SQL Server by Microsoft. It is faster than the FreeTDS version, and > is equal in speed to the DB-Library version. > > Version 1.0 is publically available at SourceForge. Version 1.1 will be > released soon. This version should interest you because it provides > support for all of the mssql_* functions. > > Let me know if you want to try it. > > -- bob > > > > On Wed, 21 Jan 2004, Alain [iso-8859-15] Barthélemy wrote: > > > Le Wednesday 21 January 2004, 10:33:38 ou environ Robert Twitty <rtwitty@xxxxxxxxxxxxxxxxx> a écrit: > > > > Hi Bob, > > > > ODBC - ODBTP? > > > > I thought of installing the ODBC driver but I read it was still in development > > and not fully operational and as long as FreeTDS worked ... > > > > Of course, I have not heard of ODBTP yet but I am not a specialist of Windows. > > > > > Hi Alain > > > > > > Would you like to try a better solution for connecting to MSSQL? It does > > > not use FreeTDS, and will not require you to change your code. It's called > > > ODBTP. > > > > > > -- bob > > > > > > On Wed, 21 Jan 2004, Alain [iso-8859-15] Barthélemy wrote: > > > > > > > It is not directly PHP but it is Db with PHP/Linux > > > > > > > > Linux 2.4.19-4GB > > > > Apache: httpd-2.0.48 > > > > php-4.3.4 > > > > freetds-0.61.2 > > > > > > > > I have php pages to connect to MsSQL-2000 server > > > > > > > > $conn = mssql_connect($server, $user, $pass) > > > > or die "...."; > > > > > > > > or (PEAR:Db) > > > > > > > > $dsn = "mssql://$user:$pass@$host/$dbname"; > > > > if (DB::isError($db)) {die ($db->getMessage()); } > > > > > > > > PHP-pages with these instructions worked this morning. > > > > Later and still now: DB error connect failed : impossible to connect now. > > > > > > > > I suspect the MsSQL server to be overloaded. > > > > > > > > Other users (Windows) are connecting via piped names > > > > > > > > Myself (on Linux) connect via IP-address > > > > > > > > If I reboot in Windows-2000 (Dual-boot system): no problem to access Db (piped > > > > name). > > > > > > > > If I make a test (on Linux) with tsql (FreeTDS): connection OK > > > > > > > > Only problem is to try connecting through Apache/PHP on Linux via IP-Address > > > > > > > > I had once problem making a DHCP enquiry on a Windows server from a Linux Host > > > > and I had to increase the TimeOut thus I wondered if I do not have the same > > > > problem now. > > > > > > > > I checked thus /www/conf/php.ini > > > > I uncommented the lines: > > > > > > > > mssql.connect_timeout = 10 > > > > mssql.timeout = 60 > > > > > > > > and tried higher numbers but without success. Apache/PHP don't seem to repeat > > > > the request till success. > > > > > > > > If anybody knows of a way to awake or shake MsSQL (apart from blowing it). Of > > > > course, the obvious is to install MySQL bur I am not the master here. > > > > -- Alain Barthélemy cassandre@xxxxxxxxxxxx http://bartydeux.be Linux User #315631 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php