Tuesday, November 18, 2008

Failed to retrieve data from the database

Error : login failed once we click OK then it's shows another one

"Failed to retrieve data from the database
Details:42502:[Microsoft][OLDB SQL Server Driver][SQL Server]Invalid object name'TableName'.[Database Vendor Code:208]"

Under Database Menu select Database Set Location.
It will open Database Set Location Property Window.

At the top you can see Current Data Source and bottom Replace with.

If you expand the table in Current Data Source you can see Properties. It shows Previous database. Select the table and replace the table by selection same table in Replace With section. Click Update button.

I hope this will help you more...

For more details Refer here

No comments: