Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server

Hi guys!

I have to eat all my statements including my hat.
Our customer actually figured it out this morning by changing to the sa user
instead of a limited one. Some of the procedures didn't grant execute
permission to public.
Since I do all the parameter stuff before execute, a security exception is
never thrown.
I might argue that .Refresh should've thrown an exception, but I'm just
gonna shut up and be happy it finally works. :)

As a sidenote.. .Refresh does really not seem to be necessary. I've ran the
code without it on my client computer running Vista, and as long as the
command is given type 4, an open connection (or a string, which is bad
practice :P ), and a command name, the roundtrip is made as soon as you try
to access the parameters.

--
Lars-Erik


.

Relevant Pages

  • Re: Full daily backup with MS backup on W2k3
    ... One more question about the LOG files. ... That line is used to refresh what Windows sees in your tape device. ... If you use the refresh command you'll need ... >> Hello Dajo, ...
    (microsoft.public.windows.server.networking)
  • Re: Updating text boxes on forms
    ... this will cause a refresh also but only for the form. ... place either command after the form is suppost to change. ... how to use the file then status bar should be one of the lessons. ... look up the DoEvents command in vb help. ...
    (microsoft.public.excel.programming)
  • Re: refresh doesnt work in VS.net 2005
    ... I'm not sure what kind of web projects are you using in VS2005... ... FrontPage web projects (remote websites, ... GetLatestVersion command. ... If you're talking about the Refresh command from SolutionExplorer, ...
    (microsoft.public.vstudio.sourcesafe)
  • ON KEY LABEL command within a form
    ... appending the record to do a command like THISFORM.Refresh. ... how do I refresh the screen after running an ON KEY LABEL ...
    (microsoft.public.fox.vfp.forms)
  • Re: Problem using SP as record source with Access2002 & SQL Server 7
    ... when the user clicks the 'requery' control. ... >>> refresh command). ... >>> Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)