Hi there,

I'm facing serious problem in ASP.

I'm calling my own VB com object to update the user details to the database.

VB com object passing parameter data type is object. From ASP i'm try to pass the object to Update interface immediately i'm getting error from the Browser that "data type mismatch"

------------------------------------------------------------------------------------
Public Function update(objChannel As Object) As Boolean

Dim strSQL As String
Dim blnCon As Boolean

On Error GoTo errorhandler

update = False

If getDBConnection Then

strSQL = "UPDATE channel " & _
"SET description = '" & getSQLString(objChannel.Description) & "'," & _
"password = '" & getSQLString(objChannel.PassWord) & "'," & _
"id = '" & objChannel.ID & "'" & _
"WHERE system_id = " & CStr(mlngSystemId)

mcn.BeginTrans
mcn.Execute (strSQL)

mcn.CommitTrans

update = True
End If 'If getDBConnection

closeDB
Exit Function

errorhandler:
mlngErrNum = Err.Number
mstrErrDesc = Err.Description
update = False
-----------------------------------------------------------------------------
This com interface is working in VB application side, but not in ASP side.

Please help, my deadline is nearing.
Any kind of help or suggestion is appreciated

Thank You