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
