PB No Longer showing Database Columns

Question

PB No Longer showing Database Columns

Dom71555 (IS/IT--Management)

(OP)

11 Aug 17 15:24

Recently our database server was upgraded and although PowerBuilder runs fine, when I click design, data source for a datawindow I get the following error.

"Table "csd_currentenrollmentcount" has no columns; possible invalid table format.
Please check to see if the active DB Profile is correct.
Do you want to continue in graphics mode?"
Graphics mode does not display anything as well.

I checked that the DB Profile is correct, even created a new one thinking the other may have been corrupt. Still get the error.
Does anything need to be done to the .pbw to correct this issue?

I am using PowerBuilder 12.6 and MS SQLServer

Thank you in advance

Dominick

http://files.engineering.com/getfile.aspx?folder=3b33390f-cabb-4db6-8701-12

mbalent (Programmer) · Answer 1 · 2017-08-11 16:24:12

DB versions (old and new)?
How is PB connecting to DB? (native driver, OLEDB, etc)

Matt

"Nature forges everything on the anvil of time"
www.anvil-of-time.com

Dom71555 (IS/IT--Management) · Answer 2 · 2017-08-11 16:31:09

I am connecting using ODBC, I believe the database is MS SQLSERVER 12.0

mbalent (Programmer) · Answer 3 · 2017-08-14 12:13:23

Try to create a new db connection in PowerBuilder.

Matt

"Nature forges everything on the anvil of time"
www.anvil-of-time.com

Dom71555 (IS/IT--Management) · Answer 4 · 2017-08-15 15:51:06

I created a new ODBC DB connection and then a new DBprofile.
Still get the same message for all datawindow objects

Come Join Us!

Posting Guidelines

Jobs

PB No Longer showing Database Columns