RE: Creating ORACLE DSN

[Schreck, Tom]

I finally found the tnsnames.ora file and found the SID.   I’m in the process of putting my first application into production at my new job.  It’s also my first app written using ORACLE.  It turns out that production ORACLE is version 8.1.7.4 and development is 9.2.0.1.  I’m using a lot of left outer join in my code which apparently is not valid in 8.1.7.4.  Lessons learned.   Thanks   Tom Schreck 972-361-9943 From: Dan Blackman [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 12, 2005 1:05 PM To: list@dfwcfug.org Subject: RE: Creating ORACLE DSN   Did you create a SID in the ORACLE tnsnames.ora file?  I think that’s the name of the file.   Dan   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Schreck, Tom Sent: Wednesday, January 12, 2005 7:57 AM To: list@dfwcfug.org Subject: Creating ORACLE DSN   I’m trying to create a DSN to my ORACLE production box.  It’s getting hung up on SID Name attribute.  I’m comparing what I’m trying to do with an existing ORACLE DSN (to our development box which connection works).  The dev DSN uses the name of the dev server in the SID Name attribute.  I tried the production server name and it fails.  Any ideas?   Thanks   Tom Schreck Applications Developer Dresser, Inc. 15455 Dallas Parkway, Suite 1100 Addison, TX  75001-4690 972-361-9943 [EMAIL PROTECTED]

<<attachment: image001.jpg>>