hi there,
i have been trying to connect to a sql 2000 server database. I am able to connect
using the DSN-connection: i.e., the following code works:
<?php
$dsn = "btc";
$user = "";
$password = "";
$sqlconnect = odbc_connect ($dsn, $user, $password);
$sqlquery = "SELECT FullDescrp FROM BTCCode3;";
$process = odbc_exec ($sqlconnect, $sqlquery);
echo $sqlquery;
echo "<br><br>";
while (odbc_fetch_row ($process))
{
$Description = odbc_result($process, "FullDescrp");
echo "$Description <br>";
}
odbc_close ($sqlconnect);
?>
But when i try to connect to the database using the mssql_xxxx functions like:
<?php
$dsn = "btc";
$user = "";
$password = "";
$myDB = "BACSDB_test";
$sqlconnect = mssql_connect ("$localhost", $user, $password);
$sqldb = mssql_select_db($myDB, $sqlconnect) or die("Couldn't open database $myDB");
$sqlquery = "SELECT FullDescrp FROM BTCCode3;";
$result = mssql_query ($sqlquery);
echo $sqlquery;
echo "<br><br>";
while ($row = mssql_fetch_array ($result))
{
echo $row['FullDescrp']."<br>\n";
}
mssql_close ($sqlconnect);
?>
It is not getting conencted. The following error is given:
"Warning: mssql_connect(): message: Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection. (severity 14) in c:\program
files\apache group\apache\htdocs\btc_test.php on line 8
Warning: mssql_connect(): Unable to connect to server: in c:\program files\apache
group\apache\htdocs\btc_test.php on line 8
Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in
c:\program files\apache group\apache\htdocs\btc_test.php on line 9
Couldn't open database BACSDB_test"
Please help....
Any help received will be highly appreciated.
thanks
penjo
Yahoo! India Matrimony: Find your life partneronline.
