Hi, Eric: I use both, although I found that I have only been using Windows Auth when I log on, since I have not yet figured out how to get the "mssql server auth" to work. Would this matter with the connection? What year is this dll file? Last time when I downloaded one from online, (I am not sure what year it was published), my PHP could no longer wrong. But, I will give it a shot. Alice -----Original Message----- From: Eric [mailto:blueray2048@xxxxxxxxx] Sent: Thursday, June 19, 2008 3:32 AM To: PHP-WINDOWS; Wei, Alice J. Subject: Re: MSSQL and ODBC Connections with PHP on Windows Please download this newer ntwdblib.dll from here http://myprojects.srhost.info/download/ntwdblib.zip and place this file into %systemroot%\system32 folder Also, do you use intergrated auth. or mixed auth mode of mssql server auth. ? ----- 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
