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 database at all, not even to mention that this means I cannot retrieve the data from the data source. Does this give you more information of why am I not getting any data output or trouble with connections? Alice -----Original Message----- From: Eric Lee [mailto:eric@xxxxxxxxxxxxxxxxxxxxxx] Sent: Wednesday, June 18, 2008 6:55 PM To: Wei, Alice J.; Zephaniah ha Levi; php-windows@xxxxxxxxxxxxx Subject: Re: 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 connection to the server without error ? 2.) Able to select a different database ? 3.) get the data from database you need to use. It is best also provide the error messages that displayed on your screen. Regards, Eric : :----- Original Message ----- :From: "Wei, Alice J." <ajwei@xxxxxxxxxxx> :To: "Zephaniah ha Levi" <zleviticus@xxxxxxxxxxxxxx>; <php-windows@xxxxxxxxxxxxx> :Sent: Thursday, June 19, 2008 4:47 AM :Subject: RE: MSSQL and ODBC Connections with PHP on Windows : : :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: : :<html> :<head> :<title>PHP SQL Database</title> :</head> :<body> :<?php :echo "<p>hello</p>"; :$server = "localhost,1433"; :$username = "username"; :$password = "pass"; :$sqlconnect = mssql_connect($server, $username, $password) or DIE("Can't :Connect to server."); :$sqldb = mssql_select_db("mydb", $sqlconnect); :$SqlSelectData = "select Name from patient"; :$results = mssql_query($SqlSelectData); :while($nameresults = mssql_fetch_array($results)){ :$Name = $namereults['Name']; :echo "<p>Here are the results:</p>"; :echo "<p>$Name<br>"; :$n++; :} :mssql_close($sqlconnect); :?> :</body> :</html> : :In my php.ini file, extension=php_mssql.dll was downloaded and loaded into C:/PHP/ext. I have added a line to give me errors, and it does pop up a window that says mssql was loaded. Therefore, does this mean that my extension is working? Or, is there is any glitch for me to see additonal error reports to show what kind of error I may be really getting? : :Thanks in advance. : :Alice :====================================================== :Alice Wei :MIS 2009 :School of Library and Information Science :Indiana University Bloomington :ajwei@xxxxxxxxxxx :________________________________________ :From: Zephaniah ha Levi [zleviticus@xxxxxxxxxxxxxx] :Sent: Wednesday, June 18, 2008 10:53 AM :To: Wei, Alice J.; php-windows@xxxxxxxxxxxxx :Subject: RE: MSSQL and ODBC Connections with PHP on Windows : :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 = mssql_query($SqlSelectData); : :while($nameresults = mssql_fetch_array($results)){ : $Name = $namereults(['Name']); :echo "$Name<br>"; :} :Mssql_Close($sqlconnect) : : :Or somethignt like that. You need to make sure that the mssql extension is :loaded in your php.ini. :-----Original Message----- :From: Wei, Alice J. [mailto:ajwei@xxxxxxxxxxx] :Sent: Wednesday, June 18, 2008 10:45 AM :To: php-windows@xxxxxxxxxxxxx :Subject: MSSQL and ODBC Connections with PHP on Windows : :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@xxxxxxxxxxx : :-- :PHP Windows Mailing List (http://www.php.net/) :To unsubscribe, visit: http://www.php.net/unsub.php : :-- :PHP Windows Mailing List (http://www.php.net/) :To unsubscribe, visit: http://www.php.net/unsub.php :
