If I add an ODBC Connector with the same name as the database the report then asks for a SQL username and password and when entered it prints.

How can I avoid the username password error

Add the CSCOM table to your report. You can link any table in your report to CSCOM by linking from the AUDTORG field to the CSCOM table.

When Sage loads a report, it will look for that table and if it sees it, it will start the process of re-assigning the database connections of the tables in that report. If it does not see that table, then it doesn't make any changes to the database connections within the report and thus you're being asked for the password.

Hi there,

The CSCOM table is already in the report.

The interesting thing is that the issue is for all ODBC based reports, whether they are custom or system

I've also had recent issues with custom Crystal reports and the new ODBC driver 18 for SQL server. My temporary solution was to remove the 18 driver and put back the 11 driver.  

Thanks will give that a go

Nope that didn't work

Darn. I have no other suggestions, but if you get it figured out please post the solution here. This change to user security with 2023 PU3+ and 2024 has caused me a few issues along the way.

Hi Skuman, 

Not sure what module your report is based on.. but in each program module there is a "rpt.ini" file (eg. for Order Entry there is an oerpt.ini file in the OEXX directory.

if the Datapipe (or odbc report) is an invoice form (example OEINV01.rpt) you can edit the ini file and locate the appropriate section (eg OEINV01)

edit to :

save it and try the report.. if you have a customization directory make sure that this file is also copied into the appropriate directory.

Same goes for the other modules such as Purchase Orders (PO).

Hope this helps.

Regards,

DCrampton