Re: PHP - MsSQL - "DB error connect failed"

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

 



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


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

  Powered by Linux