Re: ORACLE ODBC Problems

In article <2upb3q$6n9_at_reeve.research.aa.wl.com> lemckes_at_aa.wl.com writes:

>T:138.244.70.1/1525:LADA
> ^^^^
>you probably also need the port number -- 1525 for SQL*Net 1,
> 1521 for SQL*Net 2

Not generally.

The port number REALLY belongs in the Services file (in the appropriate directory for the TCP/IP stack used)

A couple of brain-dead revisions of SQL*Net that couldn't read the Services file properly and insisted on the "orasrv" entry being the FIRST entry in the Services file, not in numerical order with the rest of the TCP/IP services caused many users to specify the port number in the connect string as a workaround. This is poor practice and should be avoided.

--
Bill Meahan,  Senior Developer  |        wmeahan_at_ef0424.efhd.ford.com 
Electrical & Fuel Handling Division, Ford Motor Company
      "Computers are the most stupid machines in the world -
       they do EXACTLY what you TELL them to do!" (Gus Ogletree)