Re: [PHP-DB] ODBTP 1.1 Released for MSSQL, Access, FoxPro & ODBC
Hi Alain It is very safe. The ODBTP service has been running on a production machine that is also running SQL Server 2000. It has been running without failure since 12/15/2003, and has served over 1.5 million connections. A single ODBTP server is being used to connect to several MSSQL 6.5, MSSQL 7.0, MSSQL 2000, FoxPro and Access databases. Your admin can go to http://www.ushmm.org/wlc/en and http://www.ushmm.org/namesearch/ to view example sites that are using ODBTP. Both sites are hosted on a Solaris server running Apache/PHP, and communicate with a Win 2000 server running ODBTP & SQL Server 2000. -- bob On Fri, 13 Feb 2004, Alain [iso-8859-15] Barthélemy wrote: > Le jeudi 12 février 2004, 10:04:12 ou environ Robert Twitty <[EMAIL PROTECTED]> a > écrit: > > Hi Alain > > > > > Documentation is just to manage and understand odbtp_set_attr(...) and so on > > > > Documentation for all of the odbtp functions is available in > source>/docs. You can alos view it online at > > http://odbtp.sourceforge.net/phpext-index.html > > > > -- bob > > > > Hi Bob, > > Thank you for the Url of the ODBTP documentation. Now I can work usefully. I > already transferred some FTP pages that were working without problems before > on a Linux host with FreeTDS and suddenly stopped working without reason. Now > it works! > > The only left problem is practical. I am working in a windows-addicted > environment (sorry! Just a way of speaking) and I have to use my dual-boot PC > to install ODBTP and my own old Toshiba PII labtop to install Apache/PHP/ODBTP > client. And I would like to recover the Linux partition of my DeskTop PC. It is > stupid to block a PC just to host ODBTP. > > One question: is it safe to install the ODBTP service on the MsSQL servor? It > sounds logical for me but I have to convince the Admin to do it. Then the ODBTP > and MsSQL servor addresses will be the same. > > Thanks, > > -- > 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] ODBTP 1.1 Released for MSSQL, Access, FoxPro & ODBC
Le jeudi 12 février 2004, 10:04:12 ou environ Robert Twitty <[EMAIL PROTECTED]> a écrit: > Hi Alain > > > Documentation is just to manage and understand odbtp_set_attr(...) and so on > > Documentation for all of the odbtp functions is available in source>/docs. You can alos view it online at > http://odbtp.sourceforge.net/phpext-index.html > > -- bob > Hi Bob, Thank you for the Url of the ODBTP documentation. Now I can work usefully. I already transferred some FTP pages that were working without problems before on a Linux host with FreeTDS and suddenly stopped working without reason. Now it works! The only left problem is practical. I am working in a windows-addicted environment (sorry! Just a way of speaking) and I have to use my dual-boot PC to install ODBTP and my own old Toshiba PII labtop to install Apache/PHP/ODBTP client. And I would like to recover the Linux partition of my DeskTop PC. It is stupid to block a PC just to host ODBTP. One question: is it safe to install the ODBTP service on the MsSQL servor? It sounds logical for me but I have to convince the Admin to do it. Then the ODBTP and MsSQL servor addresses will be the same. Thanks, -- 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
[PHP-DB] ODBTP 1.1 Released for MSSQL, Access, FoxPro & ODBC
ODBTP version 1.1 has been released is available at http://odbtp.sourceforge.net Many new functions and enhancements have been added to the odbtp extension. The changes make it the best PHP solutiion for connecting to MSSQL, Access, FoxPro and other Win32 ODBC accessible databases from any platform. Its native connection pool eliminates the need for persistent connectinns. All of the functions from the mssql extension are optionally supported. This means that existing PHP scripts that use the mssql extension would not have to modified to use ODBTP. The odbtp/mssql hybrid extension's performance and capabilities exceed both the FreeTDS (UNIX / Linux) and DB-Library (Win32) versions of the mssql extension. ODBTP uses Microsoft's ODBC driver for SQL Server, which is superior to FreeTDS and DB-Library when connecting to SQL Server 2000 databases. And, unlike the mssql extension, the odbtp/mssql extensinn's behaviour is exactly the same on all platforms. While the functions from the odbc extension are not supported, the odbtp extension provides better support for ODBC. Most of the odbc extension's limitations are caused by its use of ODVC 2 instead of ODBC 3, which is used by ODBTP. The odbtp extension is also considerably faster. Rather than further elaborating on why odbtp is the best sulution, which is obviously biased, the best thing is for users of the mssql and / or odbc extensions to try the odbtp extension. Not until then will they be able to determine whether or not the aforementioned is correct. And, to make it easy to try odbtp, a PEAR DB driver is included in the package. -- bob -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php