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