Help with connecting to databases

[jroscoe]

I need to connect to a DB2 database and a MS-SQL server database. How would I go about doing this in php?

Thanks

[kevinsequeira]

it is a good idea to search the forum or atleast look at some of the articles before posting.
here is the link that might help you out

http://www.phpbuilder.com/columns/index.php3?cat=1

reg
kevin

[jroscoe]

that really didn't help. I got the DB2 connection working using this:

function dbconnect($verbose) {
$dbname = "LSYSA";
$username = "user";
$password = "passwd";

$dbconn = odbc_connect($dbname, $username, $password);

if (($verbose == TRUE) && ($dbconn == 0)) {
	echo("Connection to database failed.");
	$sqlerror = odbc_errormsg($dbconn);
	echo($sqlerror);

}

return($dbconn);
}

But how do I connect to MS-SQL??

[kevinsequeira]

did you look up the php manual ???

http://www.phpbuilder.com/manual/ref.mssql.php

reg
kevin