I'm not an oracle expert but without the tns file how would sqlnet know what listener to connect to? Are you using odp.net? Perhaps those docs have some information that may help you. YOu may also serve everything through a web service and just install the oracle and tns on the webserver. We do that and it works nicely for maintenance.
David -----Original Message----- From: Andy Smith [mailto:[EMAIL PROTECTED] 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� 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
