hi there ..
I'm coding a com object for asp ..when i run/debug this com object from a vb6.0 form , everything is ok .But it doesn't work with asp.
com reaches the db and makes a simple sql-query .. that's all .. here is the functions and iis error message ..
thanks
MMD

------------------------------------------
Error Type:
TFormer (0x800A029A)
Method '~' of object '~' failed
/aspcom/comdene.asp, line 39
-------------------------------------------
Private Sub conn_open_sql()
Dim str_conn As String
 Set cn = New ADODB.Connection
    str_conn = "Provider=SQLOLEDB;User Id=ABC;Initial Catalog=test;Data Source=ABC;Integrated Security=SSPI"
    cn.CursorLocation = adUseClient
    cn.Mode = 3
    cn.Open str_conn
End Sub
Public Function getFirmaRec(ByVal str_fname As String, ByVal str_fpass As String) As ADODB.Recordset
Dim str_querySQL As String
    conn_open_sql
    str_querySQL = "select * from tbl_firma where FIRMA_LOGIN='" & str_fname & "' AND FIRMA_PASS='" & str_fpass & "'"
    Set getFirmaRec = cn.Execute(str_querySQL)
    getFirmaRec.ActiveConnection = Nothing
    cn.Close
End Function
--------------------------------------------------------

Try putting Error handling in your COM dll. Put Error lines so you can see where the error occurs. Remember to raise the error out of the dll.

Yehuda