PB No Longer showing Database Columns

Dom71555 · Aug 11, 2017

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

mbalent · Aug 11, 2017

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

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

Dom71555 · Aug 11, 2017

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

mbalent · Aug 14, 2017

Try to create a new db connection in PowerBuilder.

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

Dom71555 · Aug 15, 2017

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

PB No Longer showing Database Columns

Dom71555

IS-IT--Management

mbalent

Programmer

Dom71555

IS-IT--Management

mbalent

Programmer

Dom71555

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor