DBParms

Resolved DBParms

How-to

Votes

Undo

Roland Smith
PowerBuilder
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?

Responses (1)

Chris Pollach @Appeon Accepted Answer Pending Moderation

Thursday, 22 April 2021 20:39 PM UTC
PowerBuilder
# 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.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

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.