From: XKEAAGIPVIEZ@spammotel.co   
      
   On Wed, 12 May 2004 01:08:44 -0700, in comp.databases.oracle, Ellen K.   
   <72322.enno.esspeeayem.1016@compuserve.com> scribbled:   
      
   >Hi all,   
   >   
   >I'm a developer.  While at my current job I've been working with   
   >mostly SQL Server, now I need to connect to our Oracle Financials   
   >running on HP-UX.  The Oracle DBA set me up as a user and installed   
   >the Oracle client on my box and I have the tnsnames file, but I still   
   >can't establish a connection to the database from my development   
   >environment... I'm getting an error message "ORA-12224 TNS:no   
   >listener".   
   >   
   >At a previous company I also had Visual Studio and was able to connect   
   >to the Oracle databases from it... I want to do the same thing here,   
   >plus I need to set the Oracle database up as a "linked server" with my   
   >SQL Servers so I can make distributed transactions.   (No heart   
   >attacks please, I'm going to create a couple of tables on the Oracle   
   >side and the Oracle DBA will put triggers on them so that whenever I   
   >insert to them he grabs the data and feeds it to the canned processes   
   >in OF.)   
   >   
   >The Oracle DBA gave me a little utility with a window where I can type   
   >freehand SQL and get results but not nicely, so I know the connection   
   >isn't impossible, but I need to be able to address the Oracle database   
   >programmatically.   I thought the problem might be related to the fact   
   >that I don't see the unix box in Network, although I can ping it   
   >either by name or IP address...  the Oracle guy said for me to see it   
   >in Network he'd have to install something I forget the name of.   
   >(Something like NFS???)  Someone suggested I put an entry in the hosts   
   >file, which I did, to no avail... although I think it's in the wrong   
   >place, it's in WINNT\System32\Drivers\etc.    The Oracle guy says he   
   >thinks the problem is that the MS OLE DB Provider for Oracle doesn't   
   >know to look in the tnsnames file, but I find that difficult to   
   >believe.   He said maybe somewhere I need to enter a "path" to it...   
   >(I vaguely remember something about setting paths back in the DOS   
   >days...)   
   >   
   >So anyway, can any of you tell me what to do?   
   >   
   >Thanks very much in advance.    :)   
      
   When connecting to Oracle in Visual Studio, I have to set up a DSN in   
   Admin Tools | ODBC Data Sources.  That may be what you mean in your   
   last paragraph, that you have set it up there.  What language are you   
   using "programmatically"?   
      
   --   
   Teresa Redmond   
   Programmer/Analyst III   
   Anteon Corporation   
   tredmond at anteon dot com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)