Oracle+ASP Connection...Please Help!!!!
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
|