|
|
Posted by Erland Sommarskog on 08/10/06 10:42
bigHairy (mthomas1973@gmail.com) writes:
> We have just started with linked servers and have successfully created
> a view on SQL Server linked to a Progress database. I can query this
> view happily in Query Analyzer.
>
> I have created an ASP.NET application to display this view in a
> datagrid but I get the following error:
>
> System.Data.SqlClient.SqlException: OLE DB provider 'MSDASQL' reported
> an error. at System.Data.SqlClient.SqlConnection.OnError(SqlException
> exception, Boolean breakConnection) at
This means that the access to the remote server failed for some reason that
we don't know. Use Profiler to see what commands emits to SQL Server, and
then run those commands from Query Analyzer, to get a slightly more
informative message.
A wild guess is that the view is not updatable from the SQL Server side,
and this is why run into problems. But that is just a guess.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|