468,249 Members | 1,479 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,249 developers. It's quick & easy.

asp to asp.net syntax error

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

Nov 19 '05 #1
1 1470
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.

<am*******@gmail.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...
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

Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Steve | last post: by
1 post views Thread by Donald Canton | last post: by
3 posts views Thread by Manuel | last post: by
1 post views Thread by Hari Sekhon | last post: by
7 posts views Thread by Josh | last post: by
Banfa
5 posts views Thread by Banfa | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.