[amibroker] afl and odbc database issues

["murthysuresh" <money@xxxxxxxxxxxxxx>]

hello
i am trying to connect to my databse in mysql from afl and i get an 
error that i dont know how to fix.
odbcOpenDatabase("ODBC;DATABASE=dbtrader;DSN=mySQL 
dbtrader;OPTION=0;PORT=0;UID=root"); 
odbcGetArraySQL("SELECT * from rawdatas");

odbcGetLastError() ;

i have a user dsn setup for dbtorontotrader. however it has a password 
and i dont know how to change it in the example opendatabase option 
that TJ has provided.
i get error Data source name not found and no default driver specified
both are there on my machine. 
how do i fix this issue.


------------------------------------

Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/