• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Making schema name not show in from of tables and columns

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

Resolved Making schema name not show in from of tables and columns

  1. New
  2. How-to
0
Votes
Undo
  1. Daniel Seguin
    Daniel Seguin
  2. PowerBuilder
  3. Wednesday, 4 December 2024 20:40 PM UTC

Hello,

 

We are migrating a powerbuilder 2017 using Sybase ASE to powerbuilder 2017 using SQL Server 2022 

Currently all datawindows were created with no schema name using Sybase ASE

When I connect the same application in PB 2017 with sql server 2022, new datawindow on a table are displayed the dbo schema name in front of table and columns.

and all existing datawindows, the owner prefix does not show

I am looking for a way to make powerbuilder not use schema name throughout the application?

 

Sending Emai Attachments
Who is viewing this page
Francisco Martinez @Appeon
Daniel Seguin
Responses (2)
Daniel Seguin
Daniel Seguin Accepted Answer Pending Moderation
  1. Wednesday, 4 December 2024 21:37 PM UTC
  2. PowerBuilder
  3. # 1

Thanks Chris, I will have to wait until tomorrow to since i'm not "sa" of the sql server database.

I will let you know the result tomorrow.

 

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 4 December 2024 20:52 PM UTC
  2. PowerBuilder
  3. # 2

Hi Daniel;

  The most common cause for that is because the SS User ID that your using is not in the DBO group.  For example ...

Regards .. Chris

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.