Error Reading SQL Server 2008 Tables in SQL Server 2014

Question

Error Reading SQL Server 2008 Tables in SQL Server 2014

Dom71555 (IS/IT--Management)

(OP)

2 May 16 16:21

Recently our database was upgraded from SQL Server 2008 to 2014.
Powerbuilder 12.6 runs on this platform however datawindow objects created in 2008 produce an error when clicking on Data Source. Error states "Table 'my table' has no columns; possible invalid table format.
Please check to see if the active DB Profile is correct."

Newly created datawindow objects work correctly. What needs to be done with the DB Profile?

Thank you for your help
Dominick

mbalent (Programmer) · Answer 1 · 2016-05-03 16:00:15

What driver are you using? Have you tried creating a new db connection to SQL2014?

Matt

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

Dom71555 (IS/IT--Management) · Answer 2 · 2016-05-03 17:35:11

I am waiting to get my SSMS updated to 2014. I think you are correct, once I get that, it will include the new drivers. Then I will need to set up a new connection.

Dom71555 (IS/IT--Management) · Answer 3 · 2016-05-05 14:50:54

I got my software upgraded to SSMS 2014. I created a new ODBC connection using the latest SQL Server driver. Created a new DBProfile using the newly created ODBC data source and I still have the problem. Still receiving the message that the table does not contain any columns.

Come Join Us!

Posting Guidelines

Jobs

Error Reading SQL Server 2008 Tables in SQL Server 2014