Re: Problem querying data from Access

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: fix (fix_at_somewhere.com)
Date: 08/19/04 

Date: Wed, 18 Aug 2004 23:18:46 -0500

Thanks for replying, but none of them seems to work for me. 

--
"joker" <no-spam@netzero.com>
???????:uBYWgAQhEHA.2952@TK2MSFTNGP09.phx.gbl...
> http://www.aspfaq.com/show.asp?id=2009
>
> fix wrote:
> > Hi all,
> >
> > I am trying to pull information by query using a pretty long SQL
(feeding it
> > by ADOConnection.Execute). I get this error:
> >
> > 0x80004005
> > Unspecified error
> >
> > If I change that to a simple "SELECT * FROM table", it won't happen.
> >
> > I put it in view so that I can call the view instead of using the long
SQL,
> > but again, I failed.
> > I tried "SELECT * FROM view_name", "view_name", "EXEC view_name" that I
> > found in Google, I got another error:
> > ADODB.Recordset (0x800A0CC1)
> > Item cannot be found in the collection corresponding to the requested
name
> > or ordinal.
> >
> > From another Google site, I tried what it have, using a Command Object:
> >
> > Set cmd = Server.CreateObject ("ADODB.Command")
> > cmd.ActiveConnection = AdoConn
> > cmd.CommandText = "view_" & astrPosition(i)
> > Const adCmdStoredProc = &H0004
> > cmd.CommandType = adCmdStoredProc
> > Set Rs = cmd.Execute
> >
> > Still the same error.
> > Any clues?
> >
> > Thanks!
> > fix.
> > --
> >
> >
> >
>

Relevant Pages

  • Re: Problem querying data from Access
    ... fix wrote: ... > I put it in view so that I can call the view instead of using the long SQL, ... > From another Google site, I tried what it have, using a Command Object: ...
    (microsoft.public.inetserver.asp.db)
  • Re: Why am I redirected to a website in a different country?
    ... > to google.fr/ and the language will be in French. ... > fix, just wondering what is making go to the google site in France in the ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • No access to Google
    ... I'm not able to get access to the google site nor any ... that the problem may be caused by a virus called qhosts, ... my internet provider gave me a qhosts removal program, ... I would appreciate any feedback on how to fix ...
    (microsoft.public.security.virus)
  • Re: Internet Explorer Redirected
    ... >>I have been unable to get to the Google site by typing ... Instead I am redirected to an unknown search ... >>How can I fix this deception!!!! ...
    (microsoft.public.security.virus)
  • Re: Washing machine is not spinning round
    ... Hey everyone thanks very much for replying. ... I've actually been very lucky and got a guy out to fix it. ... Maybe I could fix spark plugs (if ...
    (alt.home.repair)