PHP and MSSQL 8

Hikari

When trying to connect to an mssql database with mssql 8 I always recieve this error:

Fatal error: Call to undefined function: mssql_connect() in c:\program files\apache group\apache\htdocs-snip- on line 26

I've tried putting my php_mssql.dll in every place I can think of, and the... php_mssql70.dll does not work. Does anyone have a solution for this? Thanks.

Hikari

Hmmmm, can anyone help?

echox

on window, to connect MSSQL you need php_mysqll.dll and some lib for mssql client like ntwdblib.dll.

please read manual on www.php.net

echox

on window, to connect MSSQL you need php_mysqll.dll and some lib for mssql client like ntwdblib.dll.

please read manual on www.php.net

Hikari

Hmm, php_mysqll.dll or 'php_mssql.dll'?

Hikari

Hmm, I've copied ntwdblib.dll to the system32 dir from my mssql cd, enabled the extention php_mssql.dll, made sure that the extentions dir points to './extentions'. I've installed the client tools for MSSQL 8 (thats a given), restarted the server.. but still I get Call to undefined function: mssql_connect() when I try to connect.

This is frustrating... is anyone running mssql 8 with php?

echox

i'm not sure.
i read php manual and copy ntwdblib.dll on system32 ==> not connect mssql but when i install mssql on mysql machine run php, it work. you should install mssql.

Hikari

Eh? If I didn't have mssql installed I wouldn't be having this problem. What version of mssql are you using?

Der_Fisch

did you get an error when sarting your webserver (e.g. apache)?
i had this problem with Oracle...

the PHP4 extensions are corrupt... use the extensions from PHP5 instead.... this worked fine for me.. don't know if this fits to your problem too....

Hikari

Hmm, I get no errors when I start apache. I'll go ahead and look at the other extensions however.

In the mean time I'm very curious if anyone has gotten PHP to run with mssql 8.

[edit] I just gave the php 5 extensions a try even though they were all the exact same file size and it didn't work. I was looking at ODBC as a way to connect but don't totally understand how to do it. I gave it a quick try but got some errors. I think you need some drivers but I can't find win32 versions of them.

echox

i'm using php-4.3.2 and MSSQL 2000
and php connect mssql ok

when start apache, is there a message "Unable to load dynamic library .." or "The procedure entry point php_error_docref .."

echox

if you still cant connect mssql, you can try adodb class to connect mssql through odbc

FIDO

I had a heck of a time connecting to MSSQL 8 via php but was finally able to do so using PEAR & php4.3

The code below works, but does require PEAR (and a correctly configured php.ini file, of course):

<?php
require_once 'DB.php'; //require the PEAR:😃B classes.

$db_engine = 'mssql';
$db_user = 'sa';
$db_pass = '';
$db_host = 'localhost';
$db_name = 'databasepure';

$datasource = "$db_engine://$db_user:$db_pass@$db_host/$db_name";

$db_object = DB::connect($datasource, TRUE);
// assign database object in $db_object
// if the connection fails $db_object will contain error message.

// If $db_object contains an error print out error and exit
if(DB::isError($db_object)) {
die($db_object->getMessage());
}

$db_object->setFetchMode(DB_FETCHMODE_ASSOC);

Hikari

After installing pear this script seems to run without errors. However I'm not familiar with how to preform querys using this method. What functions should I be reading up on to learn how to? PEAR?

Thanks again FIDO.

FIDO

Hi -

There are a bunch of PEAR tutorials around... most of them geared toward MySQL, however, and the syntax is just different enough that they don't work properly with MSSQL 8.

This one isn't bad, but has to be modified a bit:
http://codewalkers.com/tutorials/18/2.html

Here's a small script that works for me. It just loops through the database displaying whatever it finds:

<?
$limit = 5;

require_once 'DB.php';

$db_engine = 'mssql';
$db_user = 'sa';
$db_pass = '';
$db_host = 'localhost';
$db_name = 'databasepure';

$dsn = "$db_engine://$db_user:$db_pass@$db_host/$db_name";

$db = DB::connect($dsn);
if (DB::isError($db)) {
die ($db->getMessage());
}

if(isset($GET['start'])): $start = $GET['start']; else: $start = 0; endif;

$sql = "SELECT * FROM users ORDER BY username";
$result = $db->query($sql);
if (DB::isError($result)) {
die ($result->getMessage());
}

foreach (range($start, $start + $limit - 1) as $rownum) {
if (!$row = $result->fetchrow(DB_FETCHMODE_ASSOC, $rownum)) {
break;
}
echo $row['stuff'] . "<BR>\n";
}
$result->free();
$numrows = $db->getOne('SELECT count(*) FROM mystuff');
$db->disconnect();

if($start > 0) {
echo "<a href=\"".$SERVER['PHP_SELF']."?start=".($start - $limit)."\">Back</a><BR>\n";
}
if (($start + $limit) < $numrows) {
echo "<a href=\"".$SERVER['PHP_SELF']."?start=".($start + $limit)."\">Next</a><BR>\n";
}
?>