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 Chriss Miller 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
Joined
Sep 29, 2000
Messages
4
Location
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