I have recently upgraded several W2K 2000 machines to from Oracle 8i to ORacle 9i (one sever and several additions of personel Oracle). Oracle is up and running fine on all machines, however on the personnel Oracle machines the OLEDB MS ORA provider will not work. I have no problem with the with the ORacle OLEDB provider just the microsoft one.
Also on machines with a clean install of 9i rather than an upgrade from 8i there is no problem again.
Any ideas on how to solve this problem would be greatly appreciated