Problem with refreshing parameters in ADO

From: Culture (limivorous_at_hotmail.com)
Date: 06/22/04 

Date: 22 Jun 2004 09:44:24 -0700

My code (running in access 2002) is:

Private Sub GatherInfo_Click()
On Error GoTo Err_GatherInfo_Click
Const adCmdStoredProc = &H4
  Dim strConnect
  Dim vDatabase
  Dim vUsername
  Dim vPassword
  Set ObjConn = New ADODB.Connection

  vDatabase = "USER"
  vUsername = "PASSWORD"
  vPassword = "DB"
    
  strConnect = "Provider=MSDAORA;Data Source=" & vDatabase & ";User
ID=" & vUsername & ";Password=" & vPassword & ";"
  ObjConn.Open strConnect

  Set StdProc = New ADODB.Command
  
  Set StdProc.ActiveConnection = ObjConn
 
  StdProc.CommandType = adCmdStoredProc
  StdProc.CommandText = "P_INFO.RUNEXPORT"
  StdProc.Parameters.Refresh

  ......
  End Sub

The problem is, when it gets to StdProc.Parameters.Refresh it errors
with
"Unspecified error"
Whatever i do i can't seem to refresh the parameters....
Could it also be to do with the references????

Thanks in advance :)

Craig

Relevant Pages

  • A VB6 program to generate CONSTants for a user defined gradient
    ... EndProperty ... It may be used for amy moral purpose. ... Dim mGreen1 As Long ... Private Sub ColorDisplay_MouseDown(Button As Integer, Shift As Integer, _ ...
    (comp.lang.basic.visual.misc)
  • Re: access 2003
    ... Dim ctl As Control ... Dim rs As Recordset ... This sets the query definitions for choosing data to create an invoice using ... Event on combo box: Private Sub ChooseCust_AfterUpdate ...
    (microsoft.public.access.conversion)
  • Re: Gradient Generator BMP Tool Improved
    ... EndProperty ... It may be used for amy moral purpose. ... Dim mGreen1 As Long ... Private Sub ColorDisplay_MouseDown(Button As Integer, Shift As Integer, _ ...
    (comp.lang.basic.visual.misc)
  • Multiple Calendar Control on one page
    ... Protected WithEvents Calendar1 As System.Web.UI.WebControls.Calendar ... Private Sub Page_Init(ByVal sender As System.Object, ... Dim mo As String ...
    (microsoft.public.inetserver.asp.components)
  • Calendar Control issue.
    ... Protected WithEvents Calendar1 As System.Web.UI.WebControls.Calendar ... Private Sub Page_Init(ByVal sender As System.Object, ... Dim mo As String ...
    (microsoft.public.dotnet.framework.aspnet)