jr********@hotmail.com wrote:
Approach #1: Oracle OLEDB Provider
==================================
cst = "Provider=MSDAORA;" & ...
This is not the Oracle OLEDB provider. See the MS at the beginning of
MSDAORA? It stands for Microsoft, which is why your error message reads:
Microsoft OLE DB Provider for Oracle (0x80004005)
Use the actual OLEDB provider from Oracle. You might find this useful:
http://www.connectionstrings.com/
But there's a more foolproof way. Use the .UDL trick:
http://www.webconcerns.co.uk/asp/udl/udl.asp
--
Dave Anderson
Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.