I have to make a connection to a Oracle DB 11g with a DTS. I add the connection settings in my Oracle client TNSNAMES.ORA.
in The DTS, i choose the icone "Microsoft ODBC Driver for Oracle"
I gave the values in the fields Server : , Username : , Password :
When i push the button ok, the connection is accepted but when i return to the icon, the field "Server : " is empty.
Note that i can add a "System DSN" without any problem. I tried also with another DB of Oracle in the DTS and it work but the version of Oracle is 10 or 9 i believe.
Please help !