SQLConnect Error since upgrading to QlikView 10

diffeyj — Tue, 05 Jul 2011 04:21:08 GMT

Hi All,

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?

Regards

Josh

SQLConnect Error since upgrading to QlikView 10

prieper — Tue, 05 Jul 2011 09:45:56 GMT

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.

HTH
Peter

topic SQLConnect Error since upgrading to QlikView 10 in QlikView

SQLConnect Error since upgrading to QlikView 10

SQLConnect Error since upgrading to QlikView 10