MS-SQL Server 7.0 with PHP

Anon

Hi all!

I searched the whole Database-Forum, but I didn't found anybody, who has the same problem.

I use the IIS 5.0 and the MS SQL-Server 7.0 with SP1 on a Windows 2000 Adv. Server.

The php_mssql.dll is properly linked.

Normal PHP-Code is interpreted correctly!

But when I try to access a database:

<?
$con = mssql_connect($server,$user,$pw);
?>

I get the following error-window:

"unknown has produced an error an is to be closed" (the original errormessage is in
German)

And the IIS returns a CGI-Error.

Anybody got an idea, what this could be??

Thanks in advance!

Bye - FG

bastien

have you uncommented the MSSQL info in the php.ini file to enable support for MSSQL?

it is in the DB section

hth

bastien

Anon

Yes, I did that.

First, I thought, it is because the IUSERV (the user, which executes phpcode --> IIS) had not the apropriate rights.

But even when I execute this script from the commandline as admin, the same happens 🙁

Anon

test

Anon

<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="">
Name
<input type="text" name="user_name">
<br>
LogIn ID
<input type="text" name="user_login">
<br>
Password
<input type="text" name="user_password">
<br>
Age
<input type="text" name="user_age">
<br>
Address
<input type="text" name="user_address">
<br>
<input type="submit" name="Submit" value="Submit">
<input type="submit" name="Reset" value="Reset">
<?php

$user_name=user_name;
$user_login=user_login;
$user_password=user_password;
$user_age=user_age;
$user_address=user_address;
$link= mysql_connect("telmed.isb.elixir.com");

if (!$link = mysql_connect("telmed.isb.elixir.com"))
exit("Unable to connect to $host");
mysql_select_db("registration.registration", $link);

</form>
</body>