Can't open ODBC Connection

[tneogy1]

I have a d-link to load data into the cube from a flat file. The d-link is using ODBC connection.

When I am trying to open the d-link from Update d-link-->Edit d-link option; a new ODBC Logon window is oppening asking the userid/passwod(Please find the attachement). How can I know the ODBC datasouce name used for this particular d-link and  user-id/password.

[Danno]

You need to set the user id and password to be null. I just set up the connection so that the user and password are stated as follows:

UID=;PWD=;

Works everytime with out fail. I also use this in macros so I don't get prompted for login info when using an ODBC connection to a CSV file.

This link should help: http://www-01.ibm.com/support/docview.wss?rs=3449&context=SS9S5U&context=SSWGNW&q1=-2147467259&uid=swg21343679&loc=en_US&cs=utf-8&lang=en