>>AMCS.WORLD =
>> (DESCRIPTION =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = 146.153.100.50)(PORT = 1521))
>> (CONNECT_DATA = (SID = ORCL))
>> )
>>Does this help?
>
>As for your other reply, use the MS ODBC for Oracle [it is more recent than the ODBC Driver for Oracle].
>
>Looks like you used the Oracle EZ wizard to create this. Change AMCS.WORLD to something meaningful to you [like AMCS]. I never use their wizard because it makes dumb assumptions. Make sure the IP address, port and SID are correct. Then, AMCS would be the name of the server to use in the ODBC configuration of this DSN.
If I can use sql*net/dev 2000 does that mean my tnsnames.ora is correct? Will it work if I modify it? also id d:\orant\network\admin the correct one?
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."