MSSQL and ODBC Connections with PHP on Windows

From: Date: Wed, 18 Jun 2008 14:43:53 +0000
Subject: MSSQL and ODBC Connections with PHP on Windows
Groups: php.db 
Request: Send a blank email to php-db+get-45083@lists.php.net to get a copy of this message
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 both, and my ODBC Driver does work when I run it from the test without using PHP, and yet when I put it in PHP, my entire screen goes blank. $dsn="MSSQL"; $username="user"; $password="password"; $sqlconnect=odbc_connect($dsn,$username,$password); $sqlquery="SELECT title FROM books"; $process=odbc_exec($sqlconnect, $sqlquery); while(odbc_fetch_row($process)){ $Name = odbc_result($process,"Name"); echo "$Name<br>"; } odbc_close($sqlconnect); The similar thing happens when I use the code by using a slight modification from http://us3.php.net/manual/en/function.mssql-connect.php. Can anyone please provide me some tips and solutions on what additional modules or set up I need to get this to work? I was told that if I use Windows, I may not have to use FreeTDS. Thanks in advance. ====================================================== Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington ajwei@indiana.edu

« previous php.db (#45083) next »