1. Joe Hess
  2. PowerBuilder
  3. Wednesday, 09 January 2019

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
0
Votes
Undo

Suddenly it is working again. No clue why.

Comment
There are no comments made yet.
  1. Wednesday, 9 January 2019
  2. PowerBuilder
  3. # Permalink


There are replies in this question but you are not allowed to view the replies from this question.