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!

OLEDB error ADODB.Connection (0x800A0E7A)

633180Apr 9 2008 — edited Apr 9 2008

Hi,

I am getting following error when i am runnig follwoing code.
I have verified my DSN entries or drives, In machine i have "Microsoft ODBC driver for Oracle" no other drives installed. Please let me know i have to install any drives for this.

Please help on this.

Operating System : Windows 2000 Professional.

Code :

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=HWT;" & _
"User Id=testuser;" & _
"Password=password"
set rs = Server.CreateObject("ADODB.recordset")
rs.Open strSQL,conn

Error :

ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/time/test1.asp, line 25

Line 25 is : conn.Open "Provider=OraOLEDB.Oracle;" & _

Thanks,
Raj

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2008

Added on Apr 9 2008

#oracle-provider-for-ole-db, #windows-and-net

1 comment

6,514 views