Multiple Step OLEDB operation generated Errors

[senthil123]

classic ASP, Windows 2008 server , Oracle 10g 32 bit client, IIS 7.5

Getting error on ADODB connection open.

dim conn
set conn= server.createobject(ADODB.Connection)
conn.Connectionstring = "Provider = MSDAORA;User Id = XXXX;Password=XXX;Data Source = zzz"
conn.open (---- Throwing error)

kindly help ...

thanks in advance

[RhinoBull]

Dumb question: is Oracle Client installed and tnsnames.ora file configured on that machine?

edit: I would post/move this thread to ASP, VB Script forum.

[senthil123]

Hi.. I m using 10g 32 bit client. Able to connect from sqlplusw.

[RhinoBull]

Try using Oracle OLEDB provider instead of one from Microsoft:
Provider = OraOLEDB.Oracle;

[senthil123]

I have tried with OraOLEDB.Oracle as provided. Again I am getting the same error.