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

Popular posts from this blog

c++ - QTextObjectInterface with Qml TextEdit (QQuickTextEdit) -

javascript - angular ng-required radio button not toggling required off in firefox 33, OK in chrome -

xcode - Swift Playground - Files are not readable -