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

Resolved Tables view not expanding

  1. Issue
0
Votes
Undo
  1. Louis Arena
    Louis Arena
  2. PowerBuilder
  3. Wednesday, 31 August 2022 16:02 PM UTC

Today I cannot expand the Tables view using MSOLEDBSQL SQL Server.  I can connect, write SQL statements and retrieve results.  But when I click on the Plus button next to Tables (or views) it just hangs.  I believe it was a result of some upgrade that slipped the MSOLEDBSQL version 19 drives on my machine.  I removed these drivers and installed version 18.  I did a complete shut down / restart same issue.  I then upgraded PC21 to version 1509 and still have the same problem.  Any ideas where I can look to fix this? 

PowerBuilder 2021 connection to SQL 2016/2019
Powerbuilder atl100.dll missing when building 64 b...
Responses (1)
Louis Arena
Louis Arena Accepted Answer Pending Moderation
  1. Wednesday, 31 August 2022 16:04 PM UTC
  2. PowerBuilder
  3. # 1

The 32 bit OLE Microsoft OLE DB drivers work.

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 31 August 2022 16:30 PM UTC
Sounds like you could now have have SS "System" Table access restrictions being imposed. I would check with your DBA Team & see what they changed.
  1. Helpful
Louis Arena
  1. Louis Arena
  2. Wednesday, 31 August 2022 16:47 PM UTC
Chris, you know your stuff! You realized it had to be on the server side. Before I saw your message I reasoned that if my PC got updates, there must be updates for the server that is affecting things. Sure enough there were updates. I applied the updates, had to restart the server and all is working now.
  1. Helpful 1
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 31 August 2022 18:32 PM UTC
That is "awesome" news Louis!

I am super glad that you finally found the issue. :-)
  1. Helpful
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.