Ivr Solution

[Guest badawy200379]

I Began to Implement IVR Solution

 

And Creating vbScript

like

Const adCmdStoreProc=4

Set Cmd= CreateObject("ADODB.Command")

set cn = CreateObject("ADODB.Connection")

set rs = CreateObject("ADODB.Recordset")

cn.Open "Provider=MSDAORA;Data Source=;User Id=;Password=;"

with Cmd

.ActiveConnection=cn

.CommandType=adCmdStoreProc

.CommandText="SMS.SP_SMS_BillAmount"

.Parameters.Append cmd.CreateParameter("P_CustNo", adInteger, 1, 50, "12220120")

.Parameters.Append cmd.CreateParameter ("P_BillAmount", adVarChar, 2)

.Parameters.Append cmd.CreateParameter ("P_LastDate", adVarChar, 2)

.Execute ,,128

End With

if Cmd.Parameters("P_BillAmount").Value <> 0 then

dcAmount=Cmd.Parameters("P_BillAmount").Value

else

dcAmount=0

end if

 

 

from the begining i recieved that error

Microsoft VBScript runtime error: ActiveX component can't create object: 'ADODB.Command'

and i want to use stored procedure

 

PLZ Any one Can Help ME???????????

[SupportTeam]

This is more of a Microsoft/ADO related question rather then VoiceGuide one.

 

You need to ensure that your system has the Microsoft's database components installed to let you create 'ADODB.Command' object.

 

See:

http://msdn2.microsoft.com/en-us/data/aa937729.aspx

 

Microsoft Data Access Components (MDAC) 2.8 :

http://www.microsoft.com/downloads/details...;displaylang=en

 

 

[Guest badawy200379]

Please If any One have Solution Please Posted It

when define

Set Cmd= CreateObject("ADODB.Command")

recieve error

ActiveX component can't create object: 'ADODB.Command'

 

 

i have windows xp sp2

Because i searched for solution but did not reache

thanks

[SupportTeam]

Did you read our reply to the last post you made about this?

 

Here is the link to the previous thread started by you on same topic: http://voiceguide.com/forums/index.php?showtopic=5544

 

Please keep all posts on same topic in one thread.

Edited 04/23/2008 06:46 PM by SupportTeam
Merged two threads into one

[Guest badawy200379]

Thanks it now working