Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Issue Connecting to Tutorial Database

  1. How-to
0
Votes
Undo
  1. Roland Smith
    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? 

Issue with SnapDevelop tutorial
PowerScript Migration
Responses (3)
Roland Smith
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
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Monday, 21 June 2021 15:19 PM UTC
Thanks for sharing the solution!
  1. Helpful
Roland Smith
  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
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
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.