RE: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows

2008-06-19 Thread Wei, Alice J.
ot;Wei, Alice J." <[EMAIL PROTECTED]> To: "Zephaniah ha Levi" <[EMAIL PROTECTED]>; Sent: Thursday, June 19, 2008 4:47 AM Subject: RE: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows Hi, Using the mssql connection has so far given me more trouble, and I did

RE: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows

2008-06-18 Thread Wei, Alice J.
Sent: Wednesday, June 18, 2008 6:55 PM To: Wei, Alice J.; Zephaniah ha Levi; php-windows@lists.php.net Subject: Re: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows Hi, Could you able detail the errors ? I am prefer a method that seperate the connection steps as 1.) Could you able connectio

RE: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows

2008-06-18 Thread Wei, Alice J.
Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] From: Zephaniah ha Levi [EMAIL PROTECTED] Sent: Wednesday, June 18, 2008 10:53 AM To:

Re: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows

2008-06-18 Thread Sascha Meyer
I would recommend using PDO for MSSQL, because it performs better in most. You have to enable both php_pdo.dll and php_pdo_mssql.dll in your php.ini, restart the web server and you should be ready to go. Here's a sample code taken from http://de.php.net/manual/en/ref.pdo-dblib.php [CODE] getMess

RE: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows

2008-06-18 Thread Zephaniah ha Levi
Why use odbc? Why not something like: $server = "localhost"; $username = "USER"; $password = "Password"; $sqlconnect = mssql_connect($server, $username, $password) or DIE("Can't Connect to server."); $sqldb = mssql_select_db("DB", $sqlconnect); $SqlSelectData = "select * from tablename"; $results