Update with openquery sql server

I have been trying, but can not get the syntax properly. Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Viewed times. So, All of the databases, linked server with similar settings , logins etc. Note: linked server is referencing to pervasive database. Problem Facing; After all these users are able to login, databases are accessible, reports are running and the server ServerB is performing well, users are able to SELECT tables from Pervasive database using linked server.

The provider reported an unexpected catastrophic failure. Unknown provider error. Error for 3rd query is quit different. Same query is executing successfully on ServerA. Solution will be appreciated. Improve this question. Rajesh Ranjan. Rajesh Ranjan Rajesh Ranjan 1, 2 2 gold badges 12 12 silver badges 31 31 bronze badges. Does that work? Does it give an error? Is that a valid update statement?

JonathanFite Yes I tried that. It failing with similar error referencing to the object name. I'm going to update my question. If the exact same query works and accesses the exact same Pervasive server and database from Server A but fails on Server B, then the problem is most likely a configuration error on Server B.

Show 3 more comments. Tweet Instapaper. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects just ask the SQL optimizer He lives in Princeton, NJ with his wife and three kids.

Social Sitings. Author: SQLDenis. Categories: Data Modelling and Design.