I finally figured it out!
First the mssql.dll should be in the extensions folder in your PHP directory... ususally c:/php/extensions.
If its not, grab it out of the c:php/dlls directory and copy it to your php/extensions directory.
After that, make sure your php.ini file has this code below:
; Directory in which the loadable extensions (modules) reside.
; This should be the path to your extensions folder in the PHP directory.
extension_dir = c:/php/extensions
Another thing to note, is that if you are using Apache on a Win box, you must make sure all the slashes are forward slashes!
Here is code I used to test the connection:
<?php
$link_id = mssql_connect("server", "login_name", "login_password");
echo "Link ID: " .$link_id. "<br><br>";
$db_id = mssql_select_db("database_name", $link_id);
echo "Database ID: " .$db_id. "<br><br>";
$result_id = mssql_query("SELECT * FROM table", $link_id);
echo "Result ID: " .$result_id. "<br><br>";
$rowcount = mssql_num_rows($result_id);
echo "Row Count: " .$rowcount. "<br><br>";
?>
Hope this helps!
Sol
