I am connecting succesfully to oracle database using dbconn.MDQ file and able to generate typetrees etc. When i use same mdq in map rule i.e.
DBQUERY("select empname from emp","dbconn.mdq","localdb")
It throws ORA-12560: TNS:protocol adapter error " i am little bit surprised to see this. I am using Win 7 and WTX 8.1 with Oracle 11.(TNSPing refer 64bit folder)
No idea what to do. When i use DBQuery with connection params it is connectiong (without .mdq)
DBQUERY("select empname from emp","-DBTYPE oracle -CONNECT localdb -USERNAME aaa -PASSWORD bbb")
but above method we are not supposed to use.
Any suggestions on this much appreciated.