From: 72322.enno.esspeeayem.1016@compuserve.com   
      
   I can certainly try that, but the process of setting up an OLE DB   
   connection is really quite similar to setting up an ODBC one... if I   
   use ODBC I'm inserting an extra layer.   At the company where I used   
   Oracle before I was able to define an OLE DB connection.   Still, it   
   can't hurt to try, thanks.   :)   
      
   On Wed, 12 May 2004 14:51:04 GMT, Teresa Redmond   
    wrote:   
      
   >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"?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)