Error calling store procedure in VBscript

[DougP]

It just has two parameters ID, Pos
Error:
Microsoft VBScript runtime error '800a01be'

Object doesn't support named arguments: 'CommandText'

/sp/saveit.asp, line 24
----------

	ID=Request.QueryString("ID")
	Pos=Request.QueryString("Pos")
	
	Set cmd = server.CreateObject("ADODB.Connection")
	cmd.Open "driver=SQL Server;server=000.000.000.000;uid=user;pwd=Password;database=mydb;"

	cmd.CommandText = "InsertTransaction"
	cmd.CommandType = adCmdStoredProc
	cmd.Parameters.Refresh

	cmd.Parameters(1) =ID
	cmd.Parameters(2) = Pos
	
	cmd.Execute

DougP

 

[xwb]

CommandText is part of ADODB.Command: not ADODB.Connection

 

[DougP]

OK Thanks for that info.
I have to open a connection this is to a hosted site so I have to connect that way.
But what do I need to add to get to the "command" part?
Can you assist in modify this to make it work? I know some of this code but not much.
TIA

DougP

 

[DougP]

OK I got this now, but getting error
--------
ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/sp/saveit.asp, line 27
---------------

	Set Conn = server.CreateObject("ADODB.Connection")
	Set cmd = server.CreateObject("ADODB.Command")

	Conn.ConnectionString ="driver=SQL Server;server=205.178.152.126;uid=robot_admin;pwd=Pass-123;database=robots2000;"
    
	cmd.CommandText = "InsertTransaction"
	[COLOR=red]cmd.CommandType = adCmdStoredProc        ' <<<<< Line 27[/color]
	cmd.Parameters.Refresh
	
    cmd.ActiveConnection = Conn.ConnectionString
    'Set objparameter=objcommand.CreateParameter (name,type,direction,size,value)' see 

	Set ParmeterID = cmd.CreateParameter("Student_ID", adInteger, adParamInput,StudentID)
	Set ParmeterPos =cmd.CreateParameter("Position" , adInteger, adParamInput,Position )
	
	cmd.ParametersAppend(1) = ParmeterID 
	cmd.ParametersAppend(2) = ParmeterPos 
	
	cmd.Execute

	Conn = nothing
	cmd = nothing
	ParmeterID  = nothing
	ParmeterPos  = nothing

DougP

 

[xwb]

Possibly adCmdStoredProc is not defined. See if 4 works.

http://www.w3schools.com/ado/prop_comm_commandtype.asp

If you get errors on CreateParameter, try 3 for adInteger

http://www.w3schools.com/ado/prop_para_type.asp

and 1 for adParamInput

http://www.w3schools.com/ado/prop_para_direction.asp

.

The last bit before the execute should be

    cmd.Parameters.Append ParmeterID 
    cmd.Parameters.Append ParmeterPos

 

[ChrisHirst]

http://www.candsdesign.co.uk/articles/code/asp/vbscript-constants/

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum