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

2008-06-18 Thread Wei, Alice J.
Hi, Thanks for the follow up. To answer your questions, 1) I see no additional errors other than the messages after what I have set up for "Can't Connect to server" as appeared in my error after it dies from the connection. 2) and 3) Therefore, I cannot connect or even select a data

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

2008-06-18 Thread Wei, Alice J.
Hi, Using the mssql connection has so far given me more trouble, and I did use your code, which only gives me error messages. I did try to telnet it to make sure that the server exists, and I was in. Here is the code: PHP SQL Database hello"; $server = "localhost,1433"; $username = "user

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

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

2008-06-18 Thread Wei, Alice J.
Hi, I am a newbie using the combination of PHP and MSSQL together. Can anyone tell me which method it might be better as far as using PHP on Windows with MSSQL database on a single machine? (The PHP and MSSQL database are not set up remotely on two different servers. I have set up bot