Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-24315: illegal attribute type on .NET connection HELP

747258Jan 18 2010 — edited Jan 18 2010
Hey 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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2010
Added on Jan 18 2010
2 comments
1,446 views