MSSQL and PHP

[Feffik]

Hi, I got php & mysql working.

But i also want to use MSSQL,

but I get this error.:Fatal error: Call to undefined function: mssql_pconnect() in c:\apache\apache\htdocs\test.php on line 8

but i added extension=mssq.dll into php.ini.
anto put ntwdblib.dll into winnt/sys32.

the php / apache and mssql installed on same server.

any idea's? :S

[bastien]

Have you uncommented the mssql extension in the php.ini file?

[skyline]

I have the same problem too.....

here is my php.ini

; php.ini for PEAR tests
include_path=..
extension=php_mssql.dll

i get the error:

Fatal error: Call to undefined function: mssql_connect() in d:\php\mssql.php on line 5

mssql.php looks like this:

<?php
$user=user;
$pass=password;

mssql_connect('host',$User,$Pass);
mssql_select_db('dbname');
?>

[bastien]

shut down and restart the web server...sometimes the server doesn't pick up the ini changes...

[skyline]

yeah, that was the 1st thing that I did. made no difference unfortunately.

[Feffik]

Yea i did like all the things, so mssql should work :s

but nothing.

crazy MS crap 🙂)

[skyline]

I no longer get the "call to undefined function"....So I think i've overcome the extensions problem.

I get this message:

Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in d:\php\mssql.php on line 7

Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in d:\php\mssql.php on line 8

Here is the code:
<?php
$user="sa";
$pass="";
$conn = mssql_connect(host,$user,$pass);
$database = mssql_select_db(database',$conn);

$result=mssql_query('select * from atable',$database);
while ($row=mssql_fetch_array($result)) {
$counter++;
$c1=$row['columna'];
$c2=$row['columnb'];
echo ("$counter c1: $c1 c2: $c2<br>\n");
}

mssql_close($conn);
?>