php-sqlserver db connection

Anon

Hi All,

Based in Singapore, I am new to php and in the process of connecting to sqlserver6.5 using php4.0 in NT platform. But i am not able to - there is some error message.

Need your help. And need to know the required to configure so that the db connection could be established.

Thanks and regards,
Murugesan

Anon

Hi, just trying to help.
First, let me know what the error message is.
Second, I ever used PHP 4 in windows, but it's not as good as PHP 3 (in windows) in stability issue.
If you were only using PHP and SQL Server, i advice you to use PHP 3 instead of PHP4.

Anon

Thanks for the help and the following is the details pertaining to my problem:

Currently, i am involved in the migration of ASP/Sqlserver based application to a platform independent tool. And, i am thinking of migrating ASP script to php script. But on the database,

i do not want to migrate the current sqlserver(6.5) since it is stable.

And ultimately, the php script will be run on a unix based apache web server.

But for testing purpose, i am using windows version of php, the latest version 4.0, along with

sqlserver 6.5, all are sitting on the same windows NT server 4.0 server machine.

And in this process, when i restarted my NT server after configuring the php.ini file, i got the

following error in tandem:

Unable to load dynamic library \"./php_mssql70.dll\". the specified module could not be found.
At least one service or driver failed during system startup. use event
viewer to examine the event log for details.

After this, when i ran a test script(test1.php) in the browser, i got the following error:

Fatal error:Call to undefined function: mssql_connect() in
C:\Inetpub\wwwroot\test1.php on line 4

And the script test1.php is as follows:

////////////////////////////////////////

<body>
<?php
$db = mssql_connect(\"(localhost)\",\"root\");
mssql_select_db(\"pubs\",$db);
$result = mssql_query(\"select * from authors\",$db);
echo \"<table border=1>\n\";
echo \"<tr><td>Id</td><td>FName</tr>\n\";
while ($myrow = mssql_fetch_row($result)) {
printf(\"<tr><td>%s %s</td><td>%s</td></tr>\n\", $myrow[1], $myrow[2], $myrow[3]);
}
echo \"</table>\n\";
?>
</body>

////////////////////////////////////////

Please note that i am trying to connect to sqlserver 6.5 using the driver php_mssql70.dll driver.

Need your help to fix this.

Thanks and regards,
Murug

Anon

Have you specified mssql70.dll file location in php.ini ?
BTW, what is your web server ?

Anon

Thanks for the reply. For testing, I am using IIS4.0 as the web server. The ultimate production environment will have apache server.

I have specified the path for mssql70.dll as c:\php\extensions thru the extension_dir environment variable.

Please do help me as i may be committing some mistakes in configuring the php.ini.

Thanks and regards,
Murug.

dennisjade

murag...your connection script is doing right...it is just that maybe in the php.ini file, which will be in windows directory, does not point exactly to the file...theres and easy windows installer for php4 for your convenience..try http://php.weblogs.com...i also have a php4 running at iis5..this is the portion of the ini file

extension_dir="C:\PHP\EXTENSIONS\"
extension=php_mssql70.dll

just contact me at yahoo messager in if you need assistance...