Oracle 10g for Windows Vista released
Oracle has just released a version of its database server specific for Windows Vista, you can download Oracle Database 10g Release 2 (10.2.0.3) Enterprise/Standard Edition for Microsoft Windows Vista (slightly long name). Now, if what you want is to *develop* applications with Visual Studio 2005 in Vista that work with Oracle, the story is somewhat more complex:
- In the Visual Studio 2005 Vista machine, you must install Oracle Database 10g Client Release 2 (10.2.0.3) (same URL as the server).
- If you plan to use System.Data.OracleClient, the Oracle ADO.NET provider written by Microsoft then you're all set.
- If you plan to use ODP, the ADO.NET provider written by Oracle itself, then you must download and install Oracle10g Release 2 ODAC and Oracle Developer Tools for Visual Studio .NET (10.2.0.2.21) *after* having installed the client of Step 1, this additional installer provides the following components:
- ODP, the ADO.NET Oracle provider itself
- ODE, Oracle Database Extensions for .NET 2.0, a server add-in that allows you to write stored procedures in C# (yeah, that's right, you can use C# instead of PL/SQL)
- ODT, Oracle Developer Tools for Visual Studio 2005, a Visual Studio add-in that allows you to browse an Oracle server, create tables, view data, etc. from within the IDE
Why you have to install first the 10.2.0.3 client and after that ODP, ODE and ODT from the 10.2.0.2.21 client is beyond my comprehension but I'll better stick to the procedure.