Resolved Issue with SQL Server
- New
- Issue
-
Roland Smith
- InfoMaker
- Monday, 2 June 2025 07:07 PM UTC
InfoMaker 2022 Build 1892, SQL Server 2022, ODBC Driver 18 for SQL Server
On my laptop and most users, in the Database Painter, the tables do not show dbo in front of the table name. On this one customer site, dbo is present.
This causes a problem when viewing the SQL of the report. A message comes up that no columns were found and it asks if it should continue in graphics mode or switch to syntax mode.
In both cases we are using the default settings when creating the database profile. All that is done is type the name, select a profile from the drop-down and enter the userid/password.
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.