Re: [amibroker] afl and odbc database issues

["Tomasz Janeczko" <groups@xxxxxxxxxxxxx>]

Hello,

It is necessary to follow instructions closely.

As written here:
http://www.amibroker.com/odbc.html

ODBC connection string:

 "ODBC;DSN=SQLServer_Source;DATABASE=MyDatabase;UID=SA;PWD=abc123" is a possible connection string. 

See - password and user id are passed through connection string (PWD)

Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message ----- 
From: "murthysuresh" <money@xxxxxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Monday, June 30, 2008 8:22 PM
Subject: [amibroker] afl and odbc database issues


> 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
> 
> 
> 

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

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/