Microsoft KB Archive/817182

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

Article ID: 817182

Article Last Modified on 11/26/2007

-

APPLIES TO


 * Microsoft ADO.NET 1.1
 * Microsoft Visual Basic .NET 2003 Standard Edition
 * Microsoft Visual C# .NET 2003 Standard Edition

-



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.



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.

