Can't run sp on sybase ASE

Hi All!

I have following message from ASP

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Transaction cannot have multiple recordsets with this cursor type. Change
the cursor type, commit the transaction, or close one of the recordsets.
/pp/sptest.asp, line 24


Code is straitforward.

Function AddLandLine(created_by, id, area_cd, number, extension, tech_type,
is_odot_line, ErrMsg)
Dim conn, cmd, affected, isFatal, p, tmp

' On Error Resume Next
Set conn = GetConnection
Set cmd = Server.CreateObject("ADODB.Command")

cmd.ActiveConnection = conn
cmd.CommandText = "testdb..phone_add_land_line"
cmd.CommandType = 4 ' adCmdStoredProc
cmd.Parameters.Append(cmd.CreateParameter("@created_by", adInteger, 1, ,
created_by))
cmd.Parameters.Append(cmd.CreateParameter("@id", adInteger, 1, , id))
cmd.Parameters.Append(cmd.CreateParameter("@area_cd", adVarChar, 1, 3,
area_cd))
cmd.Parameters.Append(cmd.CreateParameter("@number", adVarChar, 1, 8,
number))
cmd.Parameters.Append(cmd.CreateParameter("@extension", adVarChar, 1, 3,
extension))
cmd.Parameters.Append(cmd.CreateParameter("@tech_type", adInteger, 1, ,
tech_type))
cmd.Parameters.Append(cmd.CreateParameter("@is_odot_line", adVarChar, 1, 1,
is_odot_line))

conn.Errors.Clear
conn.BeginTrans
cmd.Execute affected, 128 'returning no records
....

GetConnection just create and open connection with default setting using
Sybase ASE ODBC driver

I'm close to deadline!
Any comments will be appreciated!


.

Relevant Pages