System.InvalidOperationException: Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information.
- From: Prasad <prasad.hn@xxxxxxxxx>
- Date: Tue, 1 Apr 2008 04:12:39 -0700 (PDT)
I have an application which updates oracle 9i database using
oledbdataadapter.
when published and deployed its working fine in local
environment(Windows XP OS), when deployed in Windows Server 2003 OS ,
i am getting System.InvalidOperationException: Dynamic SQL generation
is not supported against a SelectCommand that does not return any
base
table information.
As per googled results i found that we need to have primary Key on
the
table, but the code works fine in development (having XP). If the
problem was with Primary key voilation then it must have not worked
locally also.
I have also used commandbuilder to enable column mapping.
i am using VS 2005 with c#
any solutions?
.
- Prev by Date: Re: How to check if SQL Server is local or remote
- Next by Date: RE: Update Excel Work***
- Previous by thread: RE: Update Excel Work***
- Next by thread: SQL Service Account
- Index(es):
Loading