SSDT 2017 - Query Designer not working for Oracle db

Question

I recently installed Visual Studio/SSDT 2017. However, the Query Designer box is greyed out when connecting to an Oracle database. I can type SQL code and execute the query but I cannot use the gui tool. When connecting to a SQL database the Query Designer works fine. This is a problem for our report developers who are not extremely technical and cannot type SQL code.

Answer 1

Hi @Cook, Terri ,

I did some research online, here is some articles from Oracle for your reference.

To connect to Oracle database, you may need to download ODAC for Visual Studio 2017.

You could follow the documentations to meet your needs.

https://www.oracle.com/tools/technologies/quickstart-visual-studio.html

https://www.oracle.com/database/technologies/dotnet-odacmsi-vs2017-downloads.html

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi Zoe -
I should have mentioned that I have installed Oracle 19c client along with Oracle Data Tools for VS 2017. I can connect to the Oracle db and run queries, however, the problem is that I have to type the code and the Query Designer tool is greyed out, whereas before our users could use the gui option to create their reports. Thanks.