Re: error to connect ASP page to Oracle

jrefactors_at_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.