Skip to Content

Need help troubleshooting Error 42S02

May 14 at 05:39 PM


avatar image
Former Member

I am using Crystal Reports 2016 Support Pack 5


I get this error when attempting to run the report and I do not understand what to do next. The table itself exisits and I am able to run queries against it in SSMS. I do not know what the word 'Public' infers here which may or may not be important.

Thank You

ke60u.png (8.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dell Stinnett-Christy May 14 at 09:42 PM

"PUBLIC" is the schema name that it's connecting to. So, your connection is not set up to look at the correct one for your report. If you're using an ODBC connection, you need to update it to connect to the correct schema (second page of the configuration - you have to log in first). If you're using an OLEDB connection, you'll have to create a new one in Crystal that points to the correct schema.


10 |10000 characters needed characters left characters exceeded