Access denied for user 'ODBC'@'localho st' (using password: NO)

[kkshansid]

i hav downloaded php script from a site but while running it gives error
Access denied for user 'ODBC'@'localho st' (using password: NO) in C:\wamp\www\for um\db.class.inc .php on line 29
i use this for my connection and works well
$conn=mysql_con nect("localhost ","root","" );
while this doesnt work
function db($localhost=' localhost',$dat abase='ncstd',$ username='root' ,$password='')

kindly help as i m new to php

[Dormilich]

@kkshansid
then you should check, whether db() works correctly.

[kkshansid]

function db($localhost='localhost',$database='ncpul1',$username='root',$password=''){
        $this->localhost=$localhost;
        $this->database=$database;
        $this->username=$username;
        $this->password=$password;
        $this->conn=mysql_connect($this->localhost,$this->username,$this->password);//line29
        mysql_select_db($this->database,$this->conn);
    }

i dont think there is any error in this function

[Dormilich]

just to make sure… how do you call db()?

[kkshansid]

on index page after including connection file function call as

$db=new db($DB_LOCALHOST,$DB_DATABASE,$DB_USERNAME,$DB_PASSWORD);

[Dormilich]

is $DB_USERNAME a variable or a constant?

[Markus]

In your first example, you say it works when user = root. However, the error is saying that you're connecting as 'ODBC' (I assume that's no username). So you're doing something wrong.

[Dormilich]

I suspect that’s the username used when no username ("", null) was given. if the username is indeed saved as DB_USERNAME (you* hardly name variables uppercase) it would be the explanation.

* at least the ones who read the naming convention