INF: Support for Oracle in Visual Studio .NET 2003 (822535)

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

REFERENCES

For additional information about the Schema Builder, visit the following Oracle Web site:

http://otn.oracle.com/products/forms/htdocs/d2k/sbus.htm

Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information. The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.