PHP with MS SQL

rtcary

I am running PHP 4.3 on a Windows server and accessing MS SQL with COM objects:

$db = new COM("ADODB.Connection");
$dsn = "DRIVER={SQL Server}; SERVER=" . $dbserver . ";UID=" . $user . ";PWD=" . $password . "; DATABASE=" . $database;
$db->Open($dsn);

Is there documentation available for the available COM objects?

Thank you,

Todd

Kudose

http://us3.php.net/COM

rtcary

Maybe I am not reading the correct part of the manual, but I do not see any examples that show the methods I am currently using. For example, to get a Session record, I do the following:

/ Get session data /
function db_get_session($dbh, $sid) {
$stmnt = "SELECT * FROM dbo.SESSION WHERE SES_ID = '" . $sid . "'";
$rs = $dbh->Execute($stmnt);
return $rs;
}

Elsewhere, in my code, I use

$rs->MoveNext();

but it is not shown (or I cannot find it).

Todd

Weedpacket

Just incidentally, why are you using ADODB to communicate with the MSSQL database instead of using one of PHP's inbuilt SQL Server interfaces?

Anyway, ADODB.Connection's interface is described here.