Problems with MTS security or Database Security ????? 
Author Message
 Problems with MTS security or Database Security ?????

hi!
Help me please!!!!!

my problem :

That is a function in a component MTS in WinNT Server

Error : 70 Permission Denied

code :

--------------------------------------------------------------------------------------------------------------------------------------------------------
Private Sub collectParams(ByRef cmd As ADODB.Command, ByVal argparams As Variant)
    Dim params      As Variant
    Dim v           As Variant
    Dim iNumeroParametros  As Integer
    Dim l           As Integer
    Dim u           As Integer
    Dim o As Variant

    If Not IsArray(argparams) Then Exit Sub
    params = argparams
    For iNumeroParametros = LBound(params) To UBound(params)
        l = LBound(params(iNumeroParametros))
        u = UBound(params(iNumeroParametros))

        If u - l = 3 Then

            If VarType(params(iNumeroParametros)(3)) = vbString Then
                v = IIf(params(iNumeroParametros)(3) = "", Null, params(iNumeroParametros)(3))
            Else
                v = params(iNumeroParametros)(3)    ' Here the problem
            End If

            cmd.Parameters.Append cmd.CreateParameter(params(iNumeroParametros)(0), _
                                                      params(iNumeroParametros)(1), _
                                                      adParamInput, _
                                                      params(iNumeroParametros)(2), v)
        Else
            MsgBox NOMBRE_MODULO, "collectParams(...): Incorrecto # de Parametros"
        End If

    Next iNumeroParametros
End Sub
--------------------------------------------------------------------------------------------------------
Thank for your help

Gre{*filter*}s

Victor



Fri, 05 Mar 2004 22:12:57 GMT  
 Problems with MTS security or Database Security ?????
It could be that you turned on the "Enable authorization checking" option,
while the user did not have enough permission to access the methods. Have a
try on turning that option off in MTS Explorer. For details, please refer
to the following article:

http://support.microsoft.com/support/kb/articles/q252/7/11.asp

On the client side, since the server component calls back, try setting
Default Authentication Level in DcomCnfg to None.

Regards,
Nick

--------------------------------------
This posting is provided solely for use by users of
http://msdn.microsoft.com/newsgroups/. It is offered "AS IS" and with no
warranties. That means there is no warranty of merchantability or fitness
for a particular purpose, and no warranty of non-infringement.



Sat, 06 Mar 2004 13:20:23 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. ASP MTS Security

2. Object security (DCOMCFG, Component Services, Security, VB6, Installation)

3. MTS and method Based security

4. Samples for MTS, multi-interface, COM samples with security

5. database security problem

6. security prompt where there is no security?

7. Access 2000 Security VS. Access XP Security

8. Use NT Security instead of SQL Security

9. MTS Security

10. MTS, DCOM, Security, and the Internet

11. MTS package security and IIS anonymous user.

12. database security problem

 

 
Powered by phpBB® Forum Software