I have installed VS 2017 and Oracle client in PC.
updated tns names in with the connection. tried to connect using sql+,it was connected.
But When I tried to connect through GridView in vb.net ,
I selected Oracle Database from gridview (choose datasource)
Datasource
Oracle Database(OLE DB)
ERROR MESSAGE SHOWING IS
oracle client and networking components were not found.
while using below:
Oracle dtabase(Oracle client)
ORA 12154 :TNS could not resolve the connect identifier specified
What could be wrong:
I installed Oracle.Manged.dataaccess
But when I click in Oracle(Change data source of New connection from server explorer ODP.NET Managed driver is not seeing.
Edit
I installed ODP.NET Managed driver through nugget to .net
now error showing is
OCIEnvCreate failed with return code 1 but error message text was not available
Appreciate the help