Can anybody tell me whether RDS support strored procedures..

Hi there,
Thankx for response.

Please go through my problem once again. I am using ADO 2.7 only but to make
3 - tier architecture it is required to use RDS feature of ADO

Here is sample code for that

con1.Open "Provider=MS Remote;Remote Provider=MSDAORA;Data
Source=tech;Remote Server=http://prashant;User
Id=prashant;Password=password"

With cmd
Set .ActiveConnection = con1
.CommandText = "select * from Accounts"
.CommandType = adCmdText
Set rs = .Execute
End With

This works fine.

But it wont work for stored procedure .

Regards
Prashant



"Master Dev" wrote in message

 > Hi!
 >
 > Why use RDS??? As far as I can see, it's a little outdated. ADO 207 has
 > indeed more features. I think that this answers your question ;o)
 >
 > Master Dev
 > (unless I am missing the point here, but I dont even use DAO anylore, all
 > ADO for Me)
 >
 > "prashantshrivas" wrote:
 >
  >> Hi,
  >>
  >> My requirement is to build 3-tier architecture.
  >>
  >> I am using ADO 2.7, and able to execute single SQL and stored procedure.
  >> But
  >> when i am trying doing the same with the RDS feature of ADO It suporrts
  >> single SQL execution but not the stored procedure. whenever i am trying
  >> to
  >> use execute method of command it gives 'unknown error' basically its an
  >> automation error.
  >>
  >> Can any body suggest any solution for that
  >>
  >> I am using Oracle.
  >>
  >> Regards
  >> Prashant shrivas
  >>
  >>
  >>
  >>
  >>
  >>
  >>
  >>
 >> Stay informed about: Can anybody tell me whether RDS support strored procedures..