Microsoft KB Archive/822535

= INF: Support for Oracle in Visual Studio .NET 2003 =

Article ID: 822535

Article Last Modified on 7/17/2003

-

APPLIES TO


 * Microsoft Visual Studio .NET 2003 Enterprise Architect

-



SUMMARY
Because of changes in the database model that is used for Oracle 8.0 and later, Visual Studio .NET 2003 no longer supports the following functions:
 * Table editing in Server Explorer
 * Table designing in Server Explorer
 * Creating database diagram
 * View designing in Server Explorer
 * View editing in Server Explorer

If you try to implement one of these functions, you receive one of the following error messages:

This back-end version is not supported to design database diagrams or tables

- or -

This back-end version is not supported to design views



MORE INFORMATION
In earlier versions of Oracle, actions such as editing table data, designing table schema, and creating and viewing database diagrams were all supported in Visual Studio .NET. Because of changes in the Oracle data model for versions 8.x and 9.x, Visual Studio .NET no longer supports these functions. These functions have been disabled because the functions can corrupt the data of a user. You can use Server Explorer to browse schema.

Other design and wizard functions (such as the data adapter wizard), are supported for Oracle 8x and 9x.

OracleClient runtime objects, such as OracleDataAdapter, OracleCommand, and OracleConnection are all supported on Oracle 8.x and later.

Note When you try to add or edit triggers or stored procedures, an error may occur. However, these items are still saved, and can be used.



WORKAROUND
To work around this issue, use the Schema Builder that is available from Oracle. The Schema Builder in included with Oracle Forms. You can download this from the following Oracle Web site:

http://otn.oracle.com/software/products/forms/content.html

