I had a qlikview file that was working all fine. I had it designed so as when someone tried to reload the data the ODBC connection opened, the user would put their database username and password, then it would start reloading (assuming they had access).
Since upgrading to QlikView 10 I now receive an error message that states:
SQL##f - SqlState: S1009, ErrorCode: 8256, ErrorMsg: [Jade Software Corporation][JADE ODBC Driver] SQLConnect requires a User ID
ODBC CONNECT To Greentree
If I put in:
ODBC CONNECT To Greentree(UserID is 'ABC', Password is 'XYZ');
then it all works a treat...
Is there a way to connect to an ODBC driver without passing a userid and password in QlikView 10?
You may create an inputbox for UserID and PW. With these values you will be able to compose a connection-string. At the end of the script you may nullify the inputboxes again.
