1. Roland Smith
  2. SnapDevelop
  3. Friday, 18 June 2021 18:14 PM UTC

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? 

Roland Smith Accepted Answer Pending Moderation
  1. Monday, 21 June 2021 13:28 PM UTC
  2. SnapDevelop
  3. # 1

My initial attempt was via ODBC.

I tried SNC and was having trouble connecting. After consulting with my DBA, I was able to get the database security updated so I can connect and see all the tables.

 

Comment
  1. Armeen Mazda @Appeon
  2. Monday, 21 June 2021 15:19 PM UTC
Thanks for sharing the solution!
  1. Helpful
  1. Roland Smith
  2. Monday, 21 June 2021 15:25 PM UTC
In MSSMS I first found my userid under Security\Logins and chose Properties from the popup menu. Then on the User Mapping tab I checked the database and the db_owner role.
  1. Helpful
There are no comments made yet.
Arnd Schmidt Accepted Answer Pending Moderation
  1. Monday, 21 June 2021 10:01 AM UTC
  2. SnapDevelop
  3. # 2

Hi Roland,

have you customized your PBTableOwner settings to be 'NO' in the pbodb.ini file or anywhere else?

Arnd

Comment
There are no comments made yet.
David Xiong @Appeon Accepted Answer Pending Moderation
  1. Monday, 21 June 2021 09:34 AM UTC
  2. SnapDevelop
  3. # 3

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

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.