Last week I did a migration of our Domino server to version 6.02 CF. On the server runs an agent that print reports with Microsoft Access. Microsoft access is using NotesSql to connect to the database. In the options of the ODBC DSN, I set a username and password (because the Access report is launched by the server). In version 5 this was working fine, but since we did the migration, for every connection with this DSN (when we launch a report with COM), Notes is asking for a password. As workaround I started the Notes client on the server. Is this a bug or a security setting ?
Second problem:
I’m using NotesSql 3.01. because version 3.02c gives me another problem: In Access a made a report with a subreport in it. The subreport is not showing any data. I don’t have this problem with version 3.01. If you open the linked tables there is no problem: all the data is visible. The problem only appears when you open the report with a subreport in it (with linked fields).