Access denied for user: 'ODBC@127.0.0.1' (Using password: NO)

air_zZZz

hello,

something strange has happend...
I have this:

$cnex = mysql_connect($host,$user,$pass);
mysql_select_db($database);
$firstResult=mysql_query($insert_query);

and it works.

few lines below i have another insert query:

$secondRresult=mysql_query($insert_query_two);

and this one gives me the
"Access denied for user: 'ODBC@127.0.0.1' (Using password: NO) " error...

any ideas?

OhLordy

Try explicitly setting the connection on the query.

$result=mysql_query($query,$connection) or die(mysql_error());

hope this helps
Rob

air_zZZz

Originally posted by OhLordy
Try explicitly setting the connection on the query.

$result=mysql_query($query,$connection) or die(mysql_error());

hope this helps
Rob

10X but it's not working
I've tried even with mysql_db_query($db,$q,$conn) but the result is the same...

I cann't figure why it tries to connect via ODBC...

I have a solution myself: to create an ODBC user - and it will work with it; but I don't want to do this 🙁(

kevinsequeira

can you paste the code for the whole page ?

reg
kevin