Skip to Main Content

Oracle Developer Tools for Visual Studio

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODT for Visual Studio 2019 - Asking to fix configuration every time

4203322Mar 3 2020 — edited Mar 5 2020

Hello guys,

I am new to the whole "app connecting to oracle" world, so please bare with me.

I recently installed visual studio 2019 and I am trying to connect to an oracle database using the EFcore. So, after several google search I can across ODT for VS2019, which I am aware is kinda new. The thing is, I installed everything and now each time I open VS and the Server Explorer Tab it shows me the following message.

pastedImage_0.png

After that, I need to close Vs, wait for it to install and re-open. Then again, when I open Server Explorer the same thing happen.

Shuld I click NO and try to add a connection it shows me the following:

pastedImage_1.png

So I am out of ideas of what I am doing wrong here. If anybody could shed some light on this I would appreciate.

Comments

Gaz in Oz

Hi limor,

what does the query return if you run it in sqlplus or sqldeveloper?

Does the column "a.json2" hold a value?

Cheers,

Gaz.

limor

Hey Gaz,

if I run the query :  SELECT a.id , a.json2, d.Classname FROM   building a, THEMATIC_SURFACE b, SURFACE_GEOMETRY c, OBJECTCLASS d  WHERE  a.grid_id_500 = 2728 AND a.id = b.BUILDING_ID AND b.LOD2_MULTI_SURFACE_ID = c.ROOT_ID AND c.GEOMETRY IS NOT NULL AND b.OBJECTCLASS_ID = d.ID

I get this result in sqldeveloper: type=VARCHAR:

IDJSON2CLASSNAME
1314867{"type":"Polygon","coordinates":[[[3481982,51,5384100,92,622,59],[3481984,51,5384091,11,626,54],[3482009,33,5384095,9,626,46],[3482007,21,5384106,12,622,34],[3481982,51,5384100,92,622,59]]]}BuildingWallSurface
1314867{"type":"Polygon","coordinates":[[[3481982,51,5384100,92,622,59],[3481984,51,5384091,11,626,54],[3482009,33,5384095,9,626,46],[3482007,21,5384106,12,622,34],[3481982,51,5384100,92,622,59]]]}BuildingWallSurface

But in cx_Oracle I get NONE vaules!!!

1 - 2

Post Details

Added on Mar 3 2020
13 comments
5,929 views