Thanks for all the replies. I'm looking to avoid the whole TNSNAMES file altogether, however. It's as archaic as DSNs! :) I'm already maintaining a whole system consisting of a master connection string file, in-memory caching (per service), connection token names for indirection - per service, for my middle-tier boxes. The last thing I need is another file to worry about, let alone a network share dependency.
Here's how my JDBC connection is designated (the 'url' in JDBC-speak): jdbc:oracle:thin:@bdev04h:1521:bproto Host, port and SID, all in one, no TNSNAMES needed. Beautiful. Don't say I can't do this in .NET?!?! Something available in Java but not in .NET, I won't stand for it.... :) On Fri, 24 Sep 2004 14:34:24 -0400, Jones, Jason <[EMAIL PROTECTED]> wrote: >The best solution I have seen is to use an LDAP address in the TNSNAMES.ORA file. The LDAP server gives the appropriate tnsname and the security hole of network share permissions is bypassed. > >This site [1] seems to have information pertinent to this method (but I didn't look at it super closely). > >HTH, >Jason > >[1] http://www.idevelopment.info/data/Oracle/DBA_tips/LDAP_OID_9.2.0/LDAP_8.sht ml > >________________________________ > >From: Unmoderated discussion of advanced .NET topics. on behalf of Knebels, Francis >Sent: Fri 9/24/2004 1:47 PM >To: [EMAIL PROTECTED] >Subject: Re: [ADVANCED-DOTNET] Oracle Connections w/o TNSNAMES File? > > > >I don't think you can get around it, but you could redirect tnsnames.ora to >a network share. Each desktop has a local tnsnames.ora that looks like: > >ifile=h:\tnsnames.ora > > >Where h:\ is some network share > >Then you only need to maintain one copy on the share. There's a problem >though. The user that runs the application will need access to the network >share. > >--F > >-----Original Message----- >From: Unmoderated discussion of advanced .NET topics. >[mailto:[EMAIL PROTECTED] On Behalf Of Andy Smith >Sent: Friday, September 24, 2004 1:21 PM >To: [EMAIL PROTECTED] >Subject: [ADVANCED-DOTNET] Oracle Connections w/o TNSNAMES File? > > >Does anyone know if it's possible to connect to Oracle using the .NET >drivers without having to have a tnsnames file ? Is there a way to bypass >the need for it? I do this with JDBC so I'm sure that I can do it >with .NET. :) > >When I look at the docs for OracleConnection.ConnectionString it does not >mention anything about ports or SIDs - or about TNS names for that matter. >It just mentions the server. We're on 8i here and I'm trying to avoid the >hassle of having to maintain a tnsnames file on each of my servers. > >Thanks. > >andy > >=================================== >This list is hosted by DevelopMentor(r) http://www.develop.com >Some .NET courses you may be interested in: > >Essential .NET: building applications and components with CSharp >August 30 - September 3, in Los Angeles >http://www.develop.com/courses/edotnet > >View archives and manage your subscription(s) at http://discuss.develop.com > > > >-------------------------------------------------------------------------- ---- >Notice: This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station, New Jersey, USA 08889), and/or its affiliates (which may be known outside the United States as Merck Frosst, Merck Sharp & Dohme or MSD and in Japan, as Banyu) that may be confidential, proprietary copyrighted and/or legally privileged. It is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please notify us immediately by reply e- mail and then delete it from your system. >-------------------------------------------------------------------------- ---- > >=================================== >This list is hosted by DevelopMentor� http://www.develop.com >Some .NET courses you may be interested in: > >Essential .NET: building applications and components with CSharp >August 30 - September 3, in Los Angeles >http://www.develop.com/courses/edotnet > >View archives and manage your subscription(s) at http://discuss.develop.com > > > >=================================== >This list is hosted by DevelopMentor� http://www.develop.com >Some .NET courses you may be interested in: > >Essential .NET: building applications and components with CSharp >August 30 - September 3, in Los Angeles >http://www.develop.com/courses/edotnet > >View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor� http://www.develop.com Some .NET courses you may be interested in: Essential .NET: building applications and components with CSharp August 30 - September 3, in Los Angeles http://www.develop.com/courses/edotnet View archives and manage your subscription(s) at http://discuss.develop.com
