BUG: The connection for an Oracle database with the ODBC driver does not appear in the Data Adapter Configuration Wizard (817182)


The information in this article applies to:

  • Microsoft ADO.NET (included with the .NET Framework 1.1)
  • Microsoft Visual Basic .NET (2003)
  • Microsoft Visual C# .NET (2003)

SYMPTOMS

When you create a new data connection to an Oracle database with the ODBC Driver (Microsoft OLE DB Provider for ODBC Drivers) in Server Explorer, the data connection does not appear in the Data Adapter Configuration Wizard of the OdbcDataAdapter.

CAUSE

Connecting to Oracle databases through ODBC is not supported by Visual Studio .NET. Therefore, the data connection does not appear in the Data Adapter Configuration Wizard of Visual Studio .NET.

RESOLUTION

To resolve the problem, use Microsoft OLE DB Provider for Oracle to create a data connection to an Oracle database, and use the OracleDataAdapter instead of the OdbcDataAdapter.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Create an ODBC driver for an Oracle database.
  2. In Microsoft Visual Studio .NET, create a new Visual Basic .NET or Visual C# .NET Windows Application project. By default, Form1 is created.
  3. On the View menu, click Server Explorer.
  4. In Server Explorer, right-click Data Connections, and then click Add Connection.
  5. In Data Link Properties, click the Provider tab, and then click Microsoft OLE DB Provider for ODBC Drivers. Click Next.
  6. Under Use data source name, click the ODBC driver that you created.
  7. Type the user name and password in the User Name and Password text boxes, and then click to select the Allow saving password check box.
  8. On the Toolbox, click the Data tab. Drag an OdbcDataAdapter to Form1.
  9. In the Data Adapter Configuration Wizard, click Next.
In Choose Your Data Connection, you see that the connection that you created in Server Explorer is not displayed.

REFERENCES

For more information, visit the following MSDN Web site:

Microsoft ODBC Drivers
http://msdn.microsoft.com/library/en-us/odbc/htm/odbc_drivers_overview.asp


Modification Type:MinorLast Reviewed:3/9/2006
Keywords:kbtshoot kbDataObject kbDatabase kbWindowsForms kbOracle kbDriver kbDataAdapter kbbug KB817182 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.