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

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