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

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:

Visual Studio .NET Integration Program (VSIP)

Microsoft Product Feedback Form

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.