ODBC_CONNECTION first attempt was a disaster

[lennie]

Hi there,

This is my first time trying to use ODBC_Connect using php script on my windows php ver4.2.2 running in IIS. I am not sure where to start or what to do. As you can see my first attempt was a failure. Please help.

Cheers,
Lennie

----- MS SQL error message ---------------

Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SHANNON\IUSR_SHANNON'., SQL state 28000 in SQLConnect in c:\inetpub\wwwroot\database\testodbc.php on line 4
failed to open database

php___________________________________
?php
// trying to use ODBC CONNECTION to database

$db = odbc_connect("phpdata","php","");
if (!$db) {
	die("failed to open database");
}

?>

---