ORA-24315: illegal attribute type on .NET connection HELP
747258Jan 18 2010 — edited Jan 18 2010Hey everyone,
I have made a simple .NET application that connects to a small Oracle database hosted on a remote server. I had the application up and running Friday, it could both read and write to the database.
I tried using the app today and got the following error message: "Oracle.DataAccess.Client.OracleException: ORA-24315: illegal attribute type" -
it occurs on my connection to the database. I can however, get into the db just fine through SQL+
I also get a notice on the bottom of my screen saying: "A first chance exception of type 'Oracle.DataAccess.Client.OracleException' occurred in Oracle.DataAccess.DLL"
Here is the code in my VB.NET app:
Dim oradb As String = "Data Source=(DESCRIPTION=" _
+ "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle2.resdat.com)(PORT=1521)))" _
+ "(CONNECT_DATA=(SERVICE_NAME=ORCL)));" _
+ "User Id=uid;Password=password;"
Dim conn As New OracleConnection(oradb)
conn.Open()
Here is my TSNAMES.ORA file:
ORACLE2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle2.resdat.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
I don't think I have done anything differently and I am completely stumped as to what happened.
No solution via Google search - so I am posting here.
Thanks in advance for any help!