When I try to run a Macro with ODBC Connect as the first step to execute a dlink from SQL SERVER 2000 to Analyst Cube, the ODBC Logon Screen appears despite the fact that the Userid and Password have been input into the macro (uid=xxx;pwd=yyy;). When I then manually input the exact Userid and Password into the now opened ODBC Logon screen the macro runs ok. The DLink was set up with the EXACT same paramaters.
Can anyone advise how to configure the macro to run without the ODBC prompt?
Have you checked that there are two places where you have to maintain the odbc options? One within the macro and the other one directly within the object?
If the datasource for ODBC requires a user name and password to log on, then these must be specified in the macro in the driver options box in the format uid = xxxx; pwd =yy.
You must also specify the username and password in the format uid = xxxx; pwd =yy in the driver options box of the ODBC logon screen in the object using the odbc connection (allocation table, D-Link or D-List import link).
I also have encountered that my dLink did not store my connection string until I rebuild the link. Whyever...