Le Wednesday 21 January 2004, 12:54:18 ou environ Robert Twitty [EMAIL PROTECTED] 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 [EMAIL
PROTECTED] 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:[EMAIL PROTECTED]/$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
[EMAIL PROTECTED]
http://bartydeux.be
Linux User #315631
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php