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