When converting from ASP to ASP.Net, it is much better to convert the use of
ADO COM to ADO.Net. COM usage in .Net requires Interop, which is difficult
and problematic, as well as costly in terms of resource usage. I would
therefore recommend converting all of your ADO COM functionality to ADO.Net.
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
Everybody picks their nose,
But some people are better at hiding it.
<amitbadgi@gmail.com> wrote in message
news:1123640061.990220.15460@g44g2000cwa.googlegro ups.com...[color=blue]
>I am gettign this error while converting an asp application to asp.net
> , its a query syntax error,
> Exception Details: System.Runtime.InteropServices.COMException:
> Syntax error in query expression 'id =System.__ComObject'.
>
> Source Error:
>
> Line 191: counter = 1Line 192: for i = 0 to ubound(emaillist)Line
> 193: rs_email = conn.execute("select * from tblusers where id =" &
> emaillist(i))Line 194: tolist = tolist & rs_email("email") & ";"Line
> 195:
>
>
> Source File: C:\Documents and Settings\amit\WebSite1\email_form.aspx
> Line: 193
>
> Stack Trace:
>
> [COMException (0x80040e14): Syntax error in query expression 'id
> =System.__ComObject'.]
> Microsoft.VisualBasic.CompilerServices.LateBinding .LateGet(Object o,
> Type objType, String name, Object[] args, String[] paramnames,
> Boolean[] CopyBack) +973
> Microsoft.VisualBasic.CompilerServices.NewLateBind ing.LateGet(Object
> Instance, Type Type, String MemberName, Object[] Arguments, String[]
> ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack) +153
> ASP.email_form_aspx.__Render__control1(HtmlTextWri ter __w, Control
> parameterContainer) in C:\Documents and
> Settings\amit\WebSite1\email_form.aspx:193
> System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer,
> ICollection children) +98
> System.Web.UI.Control.RenderChildren(HtmlTextWrite r writer) +20
> System.Web.UI.Page.Render(HtmlTextWriter writer) +27
> System.Web.UI.Control.RenderControlInternal(HtmlTe xtWriter writer,
> ControlAdapter adapter) +53
> System.Web.UI.Control.RenderControl(HtmlTextWriter writer,
> ControlAdapter adapter) +280
> System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +24
> System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> +8879
>[/color]
