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?
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.
