Multiple Step OLEDB operation generated Errors
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
Re: Multiple Step OLEDB operation generated Errors
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.
Re: Multiple Step OLEDB operation generated Errors
Hi.. I m using 10g 32 bit client. Able to connect from sqlplusw.
Re: Multiple Step OLEDB operation generated Errors
Try using Oracle OLEDB provider instead of one from Microsoft:
Provider = OraOLEDB.Oracle;
Re: Multiple Step OLEDB operation generated Errors
I have tried with OraOLEDB.Oracle as provided. Again I am getting the same error.