Re: Help using ODBC with Oracle

In a previous article, joubert_at_teldata.UUCP (Joubert Berger) says:

>I am trying to get ODBC working to connect to our Oracle RDBMS V6.
>Do I need to also use Oracle SQL*Net?

   Yes. You will need the Windows SQL*Net V1 driver for whatever network protocol you are using.

>When I make the connection right now I get an error saying invalid SID.
>Who is sending the message? Is that coming from the server or from the
>ODBC driver/SQL*Net?

   Yes 8-)

   A message phrased along the lines of "SID lookup failure" would be coming from the server. Phrased any other way and it is probably coming from one of the client layers.

   The propper SQL*Net V1 connect string will depend on what protocol you are using. For example, the TCP/IP format is:

   T:[hostname]:[Oracle SID]

e.g.:

   T:myserver:DEV

--
   - Doug Harris
     Database Administrator, System Development Division,
     Statistics Canada.        ## WHERE ALL_OPINIONS.OWNER = USER ##