I have the AdventureWorks2012 database in my local SQL Server 2017.
When I connect in PowerBuilder, the tables named HumanResources.Something, Person.Something, etc. only show the right hand part in the db painter and I get object not found error trying to select from them.
What do I need to do to make it work correctly?
Hi Roland,
Which DB drive do you use in the DB Painter for your connection? Could you provide a screenshot of your DB Painter, select statement and the error?
In my environment, I tried with MicroSoft OLE DB and SQL Native Client, everything works fine in the DB Painter and the select gets results without any error.
Here is a screenshot using MicroSoft OLE DB.
Regards,
David
