Hung on Command Execute method 
Author Message
 Hung on Command Execute method

Hi,

Do you get some error message? Could ou post it please

Thanks,

Val
Microsoft MVP

Quote:
>-----Original Message-----
>The following vb code hangs on the Command object's
>execute method.  The stored procedure is an oracle db
>stored proc.  I am using MSDAORA.1 as my provider in my
>connection string.  Any ideas are much appreciated.

>Public Function GetLookupStatus(ByVal p_arrConnectionInfo
>As Variant, ByVal p_arrInputVars As Variant) As Variant

>    Dim objConn As New ADODB.Connection
>    Dim objCmd As New ADODB.Command

>    Dim objParam As ADODB.Parameter

>    Set objConn = SetupConnection(p_arrConnectionInfo(0),
>CBool(p_arrInputVars))
>    objCmd.CommandText
>= "DEV2B.LOOKUP_ISSUE_TOOL_ISSUE_STATES"
>    objCmd.CommandType = adCmdStoredProc
>    Set objCmd.ActiveConnection = objConn

>    Set objParam = objCmd.CreateParameter("Ignore",
>adVarChar, adParamInput, 2, "")
>    objCmd.Parameters.Append objParam
>    Set objParam = Nothing
>    Set objParam = objCmd.CreateParameter("IssueStatus",
>adVariant, adParamInputOutput)
>    objCmd.Parameters.Append objParam

>    objCmd.Execute

>.



Mon, 25 Oct 2004 20:11:05 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. DataEnvironment - Changing ADO Command Execute method parameters

2. ADO Command Execute method

3. ADO Command object Execute method

4. ADO Command Execute method

5. DataEnvironment - Changing ADO Command Execute method parameters

6. command.execute didn't get executed sometimes

7. command.execute vs. connection.execute

8. How to execute a command line command from a *.HTA

9. Using the ADO Command Object to send an Execute command

10. Executing command to command line from VB App

11. Why is adoCmd.Execute just hanging (code included)?

12. DDE execute hangs in win98 but works in NT40

 

 
Powered by phpBB® Forum Software