[python-win32] ADO/ADSI script works, but not in ASP

Thu, 27 Feb 2003 15:30:38 -0600

This is a cryptographically signed message in MIME format.

--------------ms000408090408000905020907
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

No problem Matt. In fact if you need to authenticate to the AD you can 
use an alternate interface. I'm going to send you a script I use in 
private email. If anyone else is interested in this stuff I can send it 
to you too.

Wilbert, Matt (ENV) wrote:

>Jens,
>
>I had what I thought were good reasons for not believing that--
>I tried setting names/passwords in the connection object,
>connection doesn't fail, error didn't look much like an
>access problem--but after I got your message I created a local
>account on the server and it appears to have the same problem
>interactively.
>
>So this doesn't look like a Python-win32 problem at all;
>I probably just have to figure out how to authenticate to
>AD correctly.
>
>Thanks for getting me to look in the right place.
>
>Matt
>
>-----Original Message-----
>From: Jens B. Jorgensen [mailto:jens.jorgensen@tallan.com]
>Sent: Thursday, February 27, 2003 1:41 PM
>To: Wilbert, Matt (ENV)
>Cc: python-win32@python.org
>Subject: Re: [python-win32] ADO/ADSI script works, but not in ASP
>
>
>Could it be a permissions problem? The user account an ASP runs under 
>does not have the same rights you do on the desktop.
>
>Wilbert, Matt (ENV) wrote:
>
>  
>
>>I am having a problem getting Active Directory information from within an ASP page.
>>It may help you to know that I have very limited experience with ASP.
>>This running under Windows 2000, IIS 5, ActivePython 2.2.1  MDAC 2.6.
>>
>>I have constructed a minimal example.
>>
>>If open the page below, I get at "table does not exist" error (full error message also below)
>>If I call smallTestTable() from a regular python script on the same server, it works as expected.
>>I presume there is some additional magic you need to do in ASP, but I have been unable to figure
>>out what that magic is.
>>
>>Thanks for any insights you may have,
>>
>>Matt Wilbert
>>-----------------test.asp ---------------------------
>><HTML>
>><BODY>
>><table>
>><%=smallTestTable%>
>></table>
>></BODY>
>></HTML>
>>
>><SCRIPT Language="Python" RunAt="Server">
>>import win32com.client
>>
>>def smallTestTable():
>>   conn = win32com.client.Dispatch('ADODB.Connection')
>>   conn.Provider = "ADSDSOObject"
>>   conn.Open()
>>   command = """Select Name, objectClass,GivenName,sn,telephoneNumber FROM
>>            'LDAP://dc=env,dc=govt,dc=state,dc=ma,dc=us' 
>>	where objectClass = 'User' and sn ='Wilbert"""
>>   (rs,success) = conn.Execute(command)
>>   rs.MoveFirst()
>>   rs.MoveLast()
>>   returnText = "<tr><td>%d</td><td>%d</td></tr>\n" % (rs.Fields.Count, rs.RecordCount)
>>   rs.Close()
>>   conn.Close()
>>   return returnText
>>
>></SCRIPT>
>>----------end test.asp-------------------
>>
>>Error Type:
>>Python ActiveX Scripting Engine (0x80020009)
>>Traceback (innermost last): File "<Script Block >",
>>line 7, in smallTestTable (rs,success) = conn.Execute(command) File "C:\Python22\Lib\site-packages\win32\ADO.py",
>>line 1808, in Execute return self._ApplyTypes_(0x6, 1, (9, 0), ((8, 1), (16396, 18), (3, 49)), 'Execute', '{00000556-0000-0010-8000-00AA006D2EA4}',CommandText, RecordsAffected, Options) File "C:\Python22\Lib\site-packages\win32com\client\__init__.py",
>>line 341, in _ApplyTypes_ return self._get_good_object_(apply(self._oleobj_.InvokeTypes, (dispid, 0, wFlags, retType, argTypes) + args), user, resultCLSID) COM Error: Table does not exist.
>>
>>
>>
>>_______________________________________________
>>Python-win32 mailing list
>>Python-win32@python.org
>>http://mail.python.org/mailman/listinfo/python-win32
>> 
>>
>>    
>>
>
>  
>

-- 
Jens B. Jorgensen
jens.jorgensen@tallan.com

"With a focused commitment to our clients and our people, we deliver value through customized technology solutions"  

--------------ms000408090408000905020907
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIIkjCC
AqcwggIQoAMCAQICAwf4vDANBgkqhkiG9w0BAQQFADCBkjELMAkGA1UEBhMCWkExFTATBgNV
BAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBUb3duMQ8wDQYDVQQKEwZUaGF3dGUx
HTAbBgNVBAsTFENlcnRpZmljYXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25hbCBGcmVl
bWFpbCBSU0EgMjAwMC44LjMwMB4XDTAyMDcyNTIyMTMwMFoXDTAzMDcyNTIyMTMwMFowZjES
MBAGA1UEBBMJSm9yZ2Vuc2VuMQ0wCwYDVQQqEwRKZW5zMRcwFQYDVQQDEw5KZW5zIEpvcmdl
bnNlbjEoMCYGCSqGSIb3DQEJARYZamVucy5qb3JnZW5zZW5AdGFsbGFuLmNvbTCBnzANBgkq
hkiG9w0BAQEFAAOBjQAwgYkCgYEAh7kk1prczfhWLforRQ6nY0s3p8XS491ey73zs0LzqzZD
cS4CcXY6kX8yajKKVJ+rip+y/AVidFawUn4gCclZ7Ewd1liGmawe8PszXI38MXHZAKv38NBJ
zskUNrNXSR6BN9+XzkEwDinM4EW9Keq0LFnbHp70f2HxC6VFIlz+f0sCAwEAAaM2MDQwJAYD
VR0RBB0wG4EZamVucy5qb3JnZW5zZW5AdGFsbGFuLmNvbTAMBgNVHRMBAf8EAjAAMA0GCSqG
SIb3DQEBBAUAA4GBAMjwbcXiAGXuX8Zqx6dI7dRJ8yK60vE273vfzX1ib6BwW2Tav1yr+Ju5
ywrf37Jmxpqhr/dKyCL8XV0o8b3yv3I2fCfLFTvSthGgPbQ8PscvA4OIRmBVj3W3ru6sD0ji
ZxmJmP66wGUFIWHbeoDHWeR0KlNrrhYV4jWvTXzIkQvZMIICpzCCAhCgAwIBAgIDB/i8MA0G
CSqGSIb3DQEBBAUAMIGSMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIw
EAYDVQQHEwlDYXBlIFRvd24xDzANBgNVBAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlmaWNh
dGUgU2VydmljZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZyZWVtYWlsIFJTQSAyMDAwLjguMzAw
HhcNMDIwNzI1MjIxMzAwWhcNMDMwNzI1MjIxMzAwWjBmMRIwEAYDVQQEEwlKb3JnZW5zZW4x
DTALBgNVBCoTBEplbnMxFzAVBgNVBAMTDkplbnMgSm9yZ2Vuc2VuMSgwJgYJKoZIhvcNAQkB
FhlqZW5zLmpvcmdlbnNlbkB0YWxsYW4uY29tMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKB
gQCHuSTWmtzN+FYt+itFDqdjSzenxdLj3V7LvfOzQvOrNkNxLgJxdjqRfzJqMopUn6uKn7L8
BWJ0VrBSfiAJyVnsTB3WWIaZrB7w+zNcjfwxcdkAq/fw0EnOyRQ2s1dJHoE335fOQTAOKczg
Rb0p6rQsWdsenvR/YfELpUUiXP5/SwIDAQABozYwNDAkBgNVHREEHTAbgRlqZW5zLmpvcmdl
bnNlbkB0YWxsYW4uY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEEBQADgYEAyPBtxeIA
Ze5fxmrHp0jt1EnzIrrS8Tbve9/NfWJvoHBbZNq/XKv4m7nLCt/fsmbGmqGv90rIIvxdXSjx
vfK/cjZ8J8sVO9K2EaA9tDw+xy8Dg4hGYFWPdbeu7qwPSOJnGYmY/rrAZQUhYdt6gMdZ5HQq
U2uuFhXiNa9NfMiRC9kwggM4MIICoaADAgECAhBmRXK3zHT1z2N2RYTQLpEBMA0GCSqGSIb3
DQEBBAUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQH
EwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0
aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwg
RnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5j
b20wHhcNMDAwODMwMDAwMDAwWhcNMDQwODI3MjM1OTU5WjCBkjELMAkGA1UEBhMCWkExFTAT
BgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBUb3duMQ8wDQYDVQQKEwZUaGF3
dGUxHTAbBgNVBAsTFENlcnRpZmljYXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25hbCBG
cmVlbWFpbCBSU0EgMjAwMC44LjMwMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDeMzKm
Y8cJJUU+0m54J2eBxdqIGYKXDuNEKYpjNSptcDz63K737nRvMLwzkH/5NHGgo22Y8cNPomXb
DfpL8dbdYaX5hc1VmjUanZJ1qCeu2HL5ugL217CR3hzpq+AYA6h8Q0JQUYeDPPA5tJtUihOH
/7ObnUlmAC0JieyUa+mhaQIDAQABo04wTDApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJp
dmF0ZUxhYmVsMS0yOTcwEgYDVR0TAQH/BAgwBgEB/wIBADALBgNVHQ8EBAMCAQYwDQYJKoZI
hvcNAQEEBQADgYEAMbFLR135AXHl9VNsXXnWPZjAJhNigSKnEvgilegbSbcnewQ5uvzm8iTr
kfq97A0qOPdQVahs9w2tTBu8A/S166JHn2yiDFiNMUIJEWywGmnRKxKyQF1q+XnQ6i4l3Yrk
/NsNH50C81rbyjz2ROomaYd/SJ7OpZ/nhNjJYmKtBcYxggNUMIIDUAIBATCBmjCBkjELMAkG
A1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBUb3duMQ8w
DQYDVQQKEwZUaGF3dGUxHTAbBgNVBAsTFENlcnRpZmljYXRlIFNlcnZpY2VzMSgwJgYDVQQD
Ex9QZXJzb25hbCBGcmVlbWFpbCBSU0EgMjAwMC44LjMwAgMH+LwwCQYFKw4DAhoFAKCCAg8w
GAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDMwMjI3MjEzMDM5
WjAjBgkqhkiG9w0BCQQxFgQU7npXJlFM6n3+W8yp3WTdEl1r3wcwUgYJKoZIhvcNAQkPMUUw
QzAKBggqhkiG9w0DBzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcw
DQYIKoZIhvcNAwICASgwgasGCSsGAQQBgjcQBDGBnTCBmjCBkjELMAkGA1UEBhMCWkExFTAT
BgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBUb3duMQ8wDQYDVQQKEwZUaGF3
dGUxHTAbBgNVBAsTFENlcnRpZmljYXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25hbCBG
cmVlbWFpbCBSU0EgMjAwMC44LjMwAgMH+Lwwga0GCyqGSIb3DQEJEAILMYGdoIGaMIGSMQsw
CQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24x
DzANBgNVBAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNV
BAMTH1BlcnNvbmFsIEZyZWVtYWlsIFJTQSAyMDAwLjguMzACAwf4vDANBgkqhkiG9w0BAQEF
AASBgEdaG70qQc2dj2M1A/ANGEgdDqSSdFwabqURYvF+c86wUjzu/t2+Zrc/YW2yWO4nEeYZ
vxpy+kiVUA3FOppK3J8rd8sG/kM/gR0ikYsH5PGltO8mGCanlPPeyd5q++g7Hoc8tP/7yp6H
leoWYyRecHNZLwTzvoGQ8DGGtqb4ax4nAAAAAAAA
--------------ms000408090408000905020907--