ODBC Password Fails, then succeeds

Tue, 05 Apr 2011 21:35:51 GMT

I have just upgraded the server and desktop to V10 SR1 and have noticed a particularly annoying issue. For one of my reports the odbc password fails initially and provides a message indicating the password is not valid. Once I acknowledge the message the odbc connection suceeds and loads the data. If I test the odbc connection it succeeds. So far I have only noticed this for a single report so I deleted and re-added the connection but no success. When trying to publish the report it always fails. I am accessing a db2 database on an AS/400. Any ideas?

Kal

ODBC Password Fails, then succeeds

erichshiino — Mon, 18 Apr 2011 22:52:47 GMT

I had a problem like this before, later I found out it was the driver (in my case I had formatted the machine completely).

So, in the mean time I disabled the errors around the connection (it would be the same thing when you acknowledge the error). You just have to make sure that the connection is right.

I put:

set errormode= 0

connect (your string connection)

set errormode = 1

You can get error messages back after the connection with errormode=1.

The only side effect is that you will not get an error message on the connection if there is something really wrong there. You would get something trying to select a table anyway.

Rgds,

Erich

topic ODBC Password Fails, then succeeds in QlikView

ODBC Password Fails, then succeeds

ODBC Password Fails, then succeeds