Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connection Oracle with ASP

807089Jan 18 2011 — edited Jun 13 2012
Hi all.

I have problems with connection ASP and Oracle. I use Windows Server 2008 Enterprise R2 64 bit.

All this string connections not working:
cn.Open "Provider=msdaora; Data Source=ORCL; User Id=ROOT; Password=xxxxxx;"

Error:
ADODB.Connection error '800a0e7a' 
Provider cannot be found. It may not be properly installed
cn.Open "Provider=MSDAORA.1;Password=xxxxxx;User ID=ROOT;Data Source=ORCL;Persist Security Info=True;" 

Error:
ADODB.Connection error '800a0e7a' 
Provider cannot be found. It may not be properly installed
cn.Open "Provider=OraOLEDB.Oracle;ORCL;UserId=ROOT;Password=xxxxxx;" 

Error:
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed
cn.Open "Provider=MSDASQL;DRIVER={Microsoft ODBC for ORACLE};UID=ROOT;PWD=xxxxxx;Server=ORCL"

Error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
[Microsoft][Driver Manager ODBC] Data source name not found and no default driver  
cn.Open "Driver={Microsoft ODBC for Oracle};Server=ORCL;Uid=ROOT;Pwd=xxxxxx;" 

Error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
[Microsoft][Driver Manager ODBC] Data source name not found and no default driver
Can you help me?
Many thanks
MR
This post has been answered by 536166 on Jun 13 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2012
Added on Jan 18 2011
4 comments
9,795 views