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

Resolved DBParms

  1. How-to
0
Votes
Undo
  1. Roland Smith
    Roland Smith
  2. PowerBuilder
  3. Thursday, 22 April 2021 17:40 PM UTC

SQL Server and ODBC, PB 2019 GA.

When opening the SQL from the DataWindow painter in PB or IM, our we are seeing calls to sp_pkeys, sp_fkeys, sp_statistics_100, and queries against the pbcat tables. There are also queries against syscomment and syscolums.

Is there a dbparm that can be set in the IDE to eliminate or limit this?

 

Not able to PASTE an image into a question
Experiencing Issue Between PB2019R2 and SVN
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 22 April 2021 20:39 PM UTC
  2. PowerBuilder
  3. # 1

Hi Roland;

   Have you tried setting "Read Only" ON and "Use Extended Attributes" OFF?

http://docs.appeon.com/pb2017r2/connecting_to_your_database/ch14s04.html#Setting_database_preferences

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.