oracle - Visual Studio can not resolve tns -
i have problem while became terminal error since got task 'today'. tried suggested.
caused problem @ installing oracle found workaround , connect database connectionstring below, works:
data source=(description=(address_list=(address=(protocol=tcp)(host=192.168.1.1)(port=1521)))(connect_data=(service_name=mydatabase)));user id=myusername;password=mypassword;
and in database have connections table datalayer uses connect other databases. here begins problem. when try connect other databases error: ora-12154: tns:could not resolve connect identifier specified.
long story short: can not touch table. tnsping work, toad. plsql developer , visual studio can not. mean there should problem listener, sqlora, tnsnames or such specific oracle file , cant find what.
for vs i'd try putting tnsnames.ora in bin folder of app. sqlplus i'd check in c:\orant\
Comments
Post a Comment