Re: pass stored procedure parameters in asp

Then you have a permissions problem. The user account being used in your
connection string has not been granted permission to execute that
procedure.

c676228 wrote:
Hi Bob,
Nice to hear from you again.
I tried. the error is:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored
procedure 'voidTran'.

but voidTran stored procedure is there.
--
Betty


"Bob Barrows" wrote:

c676228 wrote:
Now I chnaged my code to:
cmdTemp.CommandText = "voidTran" 'stored procedure for exec void
cmdTemp.CommandType = adCmdStoredProc
cmdTemp.Parameters.Append cmdTemp.CreateParameter("productName",
adChar, adParamInput)
cmdTemp.Parameters.Append cmdTemp.CreateParameter("tranNumber",
adChar , adParamInput)
'attach store procedure parameter
cmdTemp("productName")= "AC"
cmdTemp("tranNumber")= "VKYF68483010"
cmdTemp.Execute

and the error message is like this:

You have no output parameters. Just call your procedure like this:

conn.voidTran "AC", "VKYF68483010"

Make sure the user account being used by the connection has rights to
that stored procedure.

--
HTH,
Bob Barrows

--
HTH,
Bob Barrows


.

Relevant Pages

  • RE: In MMC cant see objects in console tree container
    ... Sounds like a permissions problem? ... Has your user account been removed from any domain groups? ... I need to be able to get into the objects we created in "Queries". ...
    (microsoft.public.sms.admin)
  • Re: explorer does not work when setting up user accounts
    ... - Type cmd ... > it appears to be a permissions problem. ... upgraded the new profile and it ... >>> any time I set up a user account explorer does not start up. ...
    (microsoft.public.windowsxp.setup_deployment)
  • Re: Error Opening Database (Using DataGrid)
    ... In message, goody8 ... You might not want to leave it that way in the long run, (for security reasons), but setting it that way for this test will tell you if it's a permissions problem. ... what user account is trying to access the file and set ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Multiple accounts not accessing Security packages
    ... It sounds more like a permissions problem? ... Try using the Run As feature of XP by right clicking the executable file for the program and select the Run As item and set the user account in the "Following User" section. ... Windows Shell/User ...
    (microsoft.public.windowsxp.general)
  • Re: Error opening connection to Access (Jet) DB
    ... > The most likely cause of this problem is the default ASPNET user account ... > another user account that does have permission. ... >> When using ASP.NET and an OleDBConnection control I get this error on ... >> I have tried using a connection string, too, to no avail. ...
    (microsoft.public.dotnet.framework.aspnet)
Loading