Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exchange with ADO

Status
Not open for further replies.

Interdev

Programmer
Sep 29, 2000
4
0
0
US
I need to developer a program to receive email automatic and the attachment file, I tried the follow code:

strURLFldr = "
Conn.Provider = "ExOLEDB.DataSource"

Conn.Open strURLFldr

strSQL = "SELECT ""urn:schemas:httpmail:normalizedsubject"",""urn:s
chemas:httpmail:textdescription"",""pubdoc:publicar"",""pubd
oc:dtstart"",""pubdoc:dtend"",""pubdoc:assunto"",""pubdoc:ca
pitulo"",""pubdoc:topico"",""pubdoc:instrucao"",""pubdoc:arq
uivo"" FROM "" " & _
" WHERE ""pubdoc:documento"" = '" & strDocument & "'"

With Rs
.CursorLocation = adUseClient
.CursorType = 3
Set .ActiveConnection = Conn
.Open strSQL, Conn
Set .ActiveConnection = Nothing
End With

Set GetDocumentProperties = Rs

Conn.Close
Set Conn = Nothing


but a error occurs, the class ExOLEDB.DataSource is not recognize, where can I find this OCX or DLL to make a reference for it, I tried the more common OCX(MSADODC,MSCOMM32,MSRDC20,MSCOMCTL,MSCOMCT332), but the error occurs again.

I would like to receive a another example if possible,

Thanks a lot and excuse for my English.

Marcelo Augusto de Carvalho
From Ford Brasil
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top