Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ODP.NET - Weird Behaviour

ODP.NET - Weird Behaviour

From: Subbiah, Nagarajan <Nagarajan.Subbiah_at_aetn.com>
Date: Fri, 24 Mar 2006 15:01:15 -0500
Message-ID: <30462D80AA52E74698512ADCC4F7EAA32D74C9C5@exchange.aetvn.com>


Hi List,  

We have a VB .NET application which is using Oracle ODP.NET 9.2 version for the connectivity to the database. If the application is placed under the any folder name ends with ')', it crashes.  

Here is the Test sample code and the error message. Why does the oracle client depend on the folder name where the application resides? VB Code:
Module Module1

Sub Main()

Console.WriteLine("Starting...")

Dim cnn As New
Oracle.DataAccess.Client.OracleConnection("Password=funkadel1c;Pooling=false ; User ID=sis; Data Source=gabpro")

Try

cnn.Open()

Console.WriteLine("Open")

cnn.Close()

Console.WriteLine("Close")

Catch ex As Exception

Console.WriteLine("Error")

End Try

Console.ReadLine()

End Sub

End Module  

Error:

 Oracle.DataAccess.Client.OracleException ORA-12154: TNS:could not resolve service name at
Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)

at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)

at Oracle.DataAccess.Client.OracleConnection.Open()

at ConsoleApplication2.Module1.Main() in C:\Documents and Settings\Raja\My Documents\Projects\ConsoleApplication2(2006)\ConsoleApplication2\Module1.vb: line 8  

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 24 2006 - 14:01:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US