Re: [PHP-DB] What PHP4 use for connection to MSSQL?
""Frank M. Kromann"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > ODBC and ADO uses the same type of connection. In fact you need an ODBC DSN to connect to a database using ADO. Not quite true. ADO is designed so that it can use ODBC internally, or a different technology called OLEDB. OLEDB is faster than ODBC. See the benchmark link i gave below. > > The MSSQL functions in PHP uses a native communication with the database. This communications is faster than using ODBC but it is not as easy moving to other databases as it would be using ODBC, RDO or ADO (or whatever Microsoft is adding on top of ODBC) > > - Frank > > > For some examples of connecting PHP to ODBC, visit > > http://php.weblogs.com/odbc > > > > As to speed, definitely MSSQL using PHP is very fast. See some benchmarks: > > http://php.weblogs.com/adodb_benchmarks > > > > Try the ADODB database wrapper library also. It's ADO for PHP! > > http://php.weblogs.com/adodb (I'm the author). > > > > Regards, John > > > > "Yevgeny Dyatlov" <[EMAIL PROTECTED]> wrote in message > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > Hello , > > > > > > Can somebody help me with a question: > > > ASP use for connection to MSSQL the OLE DB for SQL Server, someone > > > tell that it's cool because it better & faster than ODBC. But in > > > PHP4 there are functions both for ODBC & MSSQL. In FAQ on > > > www.php.net - 'On Windows 95/NT machines, you can simply use the > > > included ODBC support and the correct ODBC driver.' > > > Please help! What it work in fact? And what (ASP or PHP) will faster > > > work with MSSQL on WinNT with MS IIS? > > > > > > -- > > > Best regards, > > > Yevgeny mailto:[EMAIL PROTECTED] > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] What PHP4 use for connection to MSSQL?
ODBC and ADO uses the same type of connection. In fact you need an ODBC DSN to connect to a database using ADO. The MSSQL functions in PHP uses a native communication with the database. This communications is faster than using ODBC but it is not as easy moving to other databases as it would be using ODBC, RDO or ADO (or whatever Microsoft is adding on top of ODBC) - Frank > For some examples of connecting PHP to ODBC, visit > http://php.weblogs.com/odbc > > As to speed, definitely MSSQL using PHP is very fast. See some benchmarks: > http://php.weblogs.com/adodb_benchmarks > > Try the ADODB database wrapper library also. It's ADO for PHP! > http://php.weblogs.com/adodb (I'm the author). > > Regards, John > > "Yevgeny Dyatlov" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Hello , > > > > Can somebody help me with a question: > > ASP use for connection to MSSQL the OLE DB for SQL Server, someone > > tell that it's cool because it better & faster than ODBC. But in > > PHP4 there are functions both for ODBC & MSSQL. In FAQ on > > www.php.net - 'On Windows 95/NT machines, you can simply use the > > included ODBC support and the correct ODBC driver.' > > Please help! What it work in fact? And what (ASP or PHP) will faster > > work with MSSQL on WinNT with MS IIS? > > > > -- > > Best regards, > > Yevgeny mailto:[EMAIL PROTECTED] > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] What PHP4 use for connection to MSSQL?
For some examples of connecting PHP to ODBC, visit http://php.weblogs.com/odbc As to speed, definitely MSSQL using PHP is very fast. See some benchmarks: http://php.weblogs.com/adodb_benchmarks Try the ADODB database wrapper library also. It's ADO for PHP! http://php.weblogs.com/adodb (I'm the author). Regards, John "Yevgeny Dyatlov" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello , > > Can somebody help me with a question: > ASP use for connection to MSSQL the OLE DB for SQL Server, someone > tell that it's cool because it better & faster than ODBC. But in > PHP4 there are functions both for ODBC & MSSQL. In FAQ on > www.php.net - 'On Windows 95/NT machines, you can simply use the > included ODBC support and the correct ODBC driver.' > Please help! What it work in fact? And what (ASP or PHP) will faster > work with MSSQL on WinNT with MS IIS? > > -- > Best regards, > Yevgeny mailto:[EMAIL PROTECTED] > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]