powerbuilder 12.5 dropdown issue
We have an application in PB 11.5 and recently we migrated this to PB 12.5.
Migration was successful and when we try to open the screens in the application we are getting the below error.
A database error has occurred.
Database error code: 208
Database error message:
Select Error: SQLSTATE = 42S02
Microsoft SQL Native Client
Invalid object name '************'.
where ************ --> Table name
I analyzed and found that whereever table name in the select query is mentioned without databasename and schemaname this error occurs.
If I modify the table name like databasename.schemaname.tablename then I am not getting this error.
I wonder how come it works without any error in PB 11.5 since there databasename and schemaname is not mentioned with table name.
Please confirm whether this issue belong PB 12.5 version or should I do anything.