1. Michael Kramer
  2. PowerBuilder
  3. Friday, 30 August 2019 13:21 PM UTC

IDE Setup

  • PowerBuilder 2017 R3 Standard Edition, build 1858.
  • Connected to MSSQL 2012 (SP4) using ADO.NET.
  • System Options as follows:
    • [ ON ]  Free Database Driver Libraries on Disconnect
    • [ OFF ]  Disable database connection when compiling and building


Experienced Behavior

Database Painter SELECT Odd
FROM Someone.Knows;
Error: Invalid object name 'Someone.Knows'
UserObject Painter int Behavior
SELECT Odd INTO :Behavior
FROM Someone.Knows;
Silence when compile or save

Why don't I see warnings when embedded SQL is invalid?

I tell myself IDE used to complain of my table/column name typos. Am I wrong?


Roland Smith Accepted Answer Pending Moderation
  1. Friday, 30 August 2019 14:38 PM UTC
  2. PowerBuilder
  3. # 1

PB 12.5.2 with ODBC connection to SQL Server 2016

I get the error message.


Try ODBC, SNC, or OLEDB connections to see how they handle it.


THX, Roland. I'm testing several combos. Issue repeats no matter what I do.

I verified that

1) "Disable DB connection" is OFF

2) Script painter's "Display DB warnings" is ON

3) PB IDE's DB connection is alive

TEST A: Original PC but via SNC (SQLNCLI11) => No warnings

TEST B: Other PC, PB 2017R3, #1858 via SNC to MSSQL 2016/SP1 (localDB) => No warnings

TEST C: "Other PC", PB 2019, #2082 via ODBC to SQLAny V16 => No warnings

Syntax error are caught like INTO :UNKNOWN-var -- but DB errors are NOT caught.

My gut feeling is some config option disables the DB dictionary lookups. Just no clue why.
  1. Michael Kramer
  2. Friday, 30 August 2019 15:02 PM UTC
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.