I just downloaded VS 2017. I have the server explorer window opened and connected to a database. The problem I'm having is the query designer toolbar is disabled.
to work around the issue , you can try to refer steps below may help you.
1. In the Server explorer create a new connection
You see the following window:
Then Change the data source – it is really important that you choose Microsoft SQL Server and as Data provider – .NET Framework Data Provider for OLE DB (yes, you need OLE DB, because with the native SQL Server provider, the query designer just
won’t work).
After you define your connection to the database in that manner, all new queries, that you start, will be using the Query Designer framework (the well-known MS Access-like area :) ).
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
Member
80 Points
167 Posts
Query Designer Not Working In Visual Studio 2017
Oct 23, 2017 03:41 AM|Steve Mracek|LINK
I just downloaded VS 2017. I have the server explorer window opened and connected to a database. The problem I'm having is the query designer toolbar is disabled.
Thanks
Contributor
2930 Points
1210 Posts
Re: Query Designer Not Working In Visual Studio 2017
Oct 24, 2017 02:38 AM|Deepak Panchal|LINK
Hi steve mracek,
it's looks like in Visual Studio 2017. this functionality is removed.
I also find other threads in which they had faced the same issue like yours.
Visual Query Designer
to work around the issue , you can try to refer steps below may help you.
1. In the Server explorer create a new connection
After you define your connection to the database in that manner, all new queries, that you start, will be using the Query Designer framework (the well-known MS Access-like area :) ).
Reference:
How to enable Query Designer for SQL Server in Visual Studio
Regards
Deepak
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.