Error Reading SQL Server 2008 Tables in SQL Server 2014

[Dom71555]

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]

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

Matt

"Nature forges everything on the anvil of time"

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

 

[Dom71555]

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]

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.