Hi, I'm stuck with a connection to oracle using ASP for the past 1 month. I'm pretty much new to ASP & I urgently need some help with my project. I've tried connecting to Oracle using these connection strings: -

1."Provider=OraOLEDB.Oracle.1;Password=xxx;Persi st Security Info=True;User ID=xxx;Data Source=xxx"
Error:ADODB.Recordset (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/homepage/test.asp, line 8


2. "Provider=MSDAORA.1;Password=tiger;User ID=scott;Data Source=Rase;Persist Security Info=True"
Microsoft OLE DB Provider for Oracle (0x80004005)
Oracle error occurred, but error message could not be retrieved from Oracle.
/homepage/test.asp, line 8

Now, I've tried as many solutions as provided on the net, including giving access to 'Authenticated users/IUSER_Machine name/IWAM_Machine name' but none of them worked! <I'm using Win XP with SP2> I'm really stuck but I REALLY NEED SOME HELP ASAP! Any help in this regard will be sincerely appreciated.

Please do contact me at onlysujay@gmail.com for any queries/solutions! Thanks in advance

Solution for Windows 2003 server :

"Provider=MSDAORA.1;User ID=urid;Password=urpwd;Data Source=urdatasource;Persist Security Info=False"

Microsoft OLE DB Provider for Oracle (0x80004005)
Oracle error occurred, but error message could not be retrieved from Oracle

The above works fine in windows 2003 server after the installation of service pack 2 of win2k3 and removed sqlnet.ora from the oracle folder

C.Karthikeyan