Access denied for user ''@'localhost'

I have installed mysql and ODBC on my linux machine (Fedora 7)

i can connect to the database fine from the console when typing:

do i know the database is defintley there and running

I am trying to use func_odbc in asterisk here are the contents of res_odbc.conf and func_odbc.conf:

[asterisk] dsn = asterisk-connector username = asterisk pre-connect = yes

[APP] readhandle = asterisk prefix=LOAD dsn = asterisk readsql=SELECT appid FROM DDI WHERE number = '${ARG1}'

Whenever i call LOAD_APP from asterisk it says Access denied for user ‘’@‘localhost’ ? cannot it not see the username in res_odbc.conf?[/code]

In res_odbc.conf change it to this:

[asterisk] enabled => yes dsn => asterisk-connector username => asterisk pre-connect => yes

I added the extra line

but it made no difference

any more suggestions?