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

Resolved Stored Procedure load incomplete in Database Painter

  1. Issue
0
Votes
Undo
  1. Juan Carlos Marin
    Juan Carlos Marin
  2. PowerBuilder
  3. Tuesday, 5 April 2022 00:40 AM UTC

Good evening

In the database painter when I connect by ODBC to SQL Server I can see the Stored Procedures without problem; but when I connect using MSOLEDBSQL SQL SERVER Or SNC SQL Native Client the Stored Procedures don't show complete, they only load partially in the database painter

Attachments (2)
Using MSOLEDBSQL.PNG Using MSOLEDBSQL.PNG
Using ODBC.PNG Using ODBC.PNG
Run PowerClient on VPN
call .net assembly winform error need setcompatibl...
Responses (2)
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Tuesday, 5 April 2022 13:36 PM UTC
  2. PowerBuilder
  3. # 1

Hi, Juan - 

While not an answer to your specific question/issue, I'd like to offer the suggestion for you to consider using SQL Server Management Studio (SMSS) when working with SQL Server databases, particularly if you are connecting via SQL Server Native Client or Microsoft OLE Database for SQL Server (MSOLEDBSQL). As a longtime PowerBuilder developer, I've been working with SQL Server databases exclusively for the past 12 years and believe SMSS to be a very good tool for a great price ($0).

   https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Best wishes, John

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 5 April 2022 00:48 AM UTC
  2. PowerBuilder
  3. # 2

Hi Juan;

   Sounds like a SS permissions issue. Check your DSN settings vs your MSO connection settings (credentials). A good question for your DBA.  ;-)

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.
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.