Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/811241

From BetaArchive Wiki
Knowledge Base


Info: Visual Studio .NET Designer Tool Supports Specific OLE DB Providers

Article ID: 811241

Article Last Modified on 1/10/2007



APPLIES TO

  • Microsoft Visual Studio .NET 2002 Professional Edition
  • Microsoft Visual Studio .NET 2003 Professional Edition
  • Microsoft Visual Studio .NET 2002 Enterprise Architect
  • Microsoft Visual Studio .NET 2002 Enterprise Architect
  • Microsoft Visual Studio .NET 2003 Enterprise Architect
  • Microsoft Visual Studio .NET 2002 Enterprise Developer
  • Microsoft Visual Studio .NET 2002 Enterprise Developer
  • Microsoft Visual Studio .NET 2003 Enterprise Developer



SUMMARY

The Microsoft Visual Studio .NET Designer Tool only supports the following OLE DB providers:

  • Microsoft OLE DB Provider for SQL Server
  • Microsoft Jet 4.0 OLE DB Provider
  • Microsoft OLE DB Provider for Oracle


The Designer Tool has not been tested with other Microsoft or non-Microsoft OLE DB providers. Therefore, Microsoft does not guarantee that the designer tool works correctly with other providers. Microsoft does not support any other providers (that are not in this list) through the Visual Studio .NET Designer Tool.

The Visual Data tools that are included with various versions of Microsoft Visual Studio products were not designed to be extensible by third parties, and are not supported in those scenarios. To help Microsoft better plan for future versions, submit any suggestions for features and capabilities that you want to see.

To be part of Visual Studio .NET Integration Program (VSIP), and to submit your comment, see the following Microsoft Web sites:

MORE INFORMATION

You can use the Visual Studio .NET Designer Tool to design your application with the backend datasource. With this tool you can create a datasource in Server Explorer, and drag tables and views to create OledbConnection and OLEDBDataAdapter objects.

REFERENCES

For additional information about what you can do with the Visual Studio .NET Designer Tool, click the following article number to view the article in the Microsoft Knowledge Base:

313486 INFO: Roadmap for Visual Database Tools and Typed DataSets




For additional information about Visual Studio .NET Designer Tool, click the following article numbers to view the articles in the Microsoft Knowledge Base:

316831 PRB: Cannot Configure Data Connection to Excel Files in Visual Studio .NET


318646 BUG: Visual Studio .NET Query Builder Builds Incorrect Syntax for Jet Queries That Involve Joins


325790 FIX: Providers Fail When Visual Studio Database Designer Wizard Puts Brackets Around the Table Name




Important Note Though the Visual Studio .NET Designer Tool does not support all OLE DB providers, the Microsoft .NET Framework and Microsoft ADO.NET support all third-party OLE DB providers, and also Microsoft OLE DB providers. The limitation that is described in this article is only with Visual Studio .NET Designer Tool, and not with the .NET Framework or with ADO.NET. Microsoft fully supports all programming issues that occur when you use the .NET Framework or ADO.NET with any third-party OLE DB providers.


Additional query words: DB2 IBM FoxPro

Keywords: kbinfo kb3rdparty kbdb2 KB811241