I have an oracle data on server1, and I want to connect to it using odbc on server2. I setup a System DSN with TNS service name of "server1:1521rcl" and it didn't work. Can anyone help me on this problem? I am not sure what the format of the TNS Service Name on this. I am unable to successfully connect to it using SQuirrel using jdbc.
Server1=Window 2003 Server with Oracle 10g.
Error: ORA-12545, I notice the problem occur before tcp connection since I sniff the network.
Also, how trouble is it use Oracle instead of other database such as MS SQL and MySQL? Since I start on database(3 week), I am constantly have problem with Oracle while MySQL and MS-SQL are pretty newbie friendly.