I connected to a Remote Oracle Database (with Read Only Permission) using Provider=OraOLEDB.Oracle AND Provider=MSDAORA. Developers who just need the 32-bit Oracle Client for Vista can download it at that same link.
10.2.0.3) is now available for download! It supports Vista Business, Ultimate and Enterprise Edition. The 32-bit Oracle Database 10g Release 2 for Windows Vista (v.The default directory for SQL Server is a default directory for SQL Server service account.
The main problem is that an OLE DB provider creates a temporary file during the query in the SQL Server temp directory using credentials of a user who run the query.
