1. Joe Hess
  2. PowerBuilder
  3. Wednesday, 9 January 2019 20:43 PM UTC

My installation of PB2017 has suddenly lost the ability to retrieve the list of tables from a SQL database when using the graphical builder. If I open an existing datawindow, the tables and columns appear. When I try to create a new datawindow, PB just spins. I tried viewing the list of tables in the database painter. That hangs as well. Reinstalling did not solve the problem. I can retrieve the tables from PB9. Nothing has changed as far as I know. I just applied a Windows update, but the problem started before that.

PB2017 R3, Build 1858

// Profile Test Database
SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"
SQLCA.LogPass = <*******>
SQLCA.ServerName = "10.1.1.9"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='Test',Provider='SQLNCLI11',PacketSize=16384"

Does anyone have a solution for this?

 

Thank you,

Joe Hess

Accepted Answer
Joe Hess Accepted Answer Pending Moderation
  1. Wednesday, 9 January 2019 20:49 PM UTC
  2. PowerBuilder
  3. # Permalink

Suddenly it is working again. No clue why.

Comment
There are no comments made yet.


There are replies in this question but you are not allowed to view the replies from 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.