OracleConnection conn = new OracleConnection(oradb);
I get this error.
ORA-24315: illegal attribute type
So I simplified my string connection string to:
string oradb = "Data Source=ORCL;User ID=scott;Password=tiger;";
I verified access with TOAD and ORACLE Developer. (Yes, it works)
I also reviewed my tnsnames.ora and it has ORCL as the Service name.
I noticed that the Visual Studio Data Connection Object in the Visual Studio Environment is formated as ORCL.scott. I can rename it to ORCL. It also can
connect to the database just fine. Doesn't seem to depend on tnsnames.ora.
So it seems to me the oracle.data.access is failing on me and I'm not the syntax correct. So what's going on with my program. Any ideas?
Also, Could you clarify which download I should be using. I'm afraid I might have wrong one.
Oracle Developer Tools for Visual Studio .NET with Oracle10g Release 2 ODAC 10.2.0.2.20
Oracle10g Release 2 ODAC 10.2.0.2.20
Oracle Developer Tools for Visual Studio .NET (for Oracle Database10g Express Edition)
Oracle10g ODAC 10.1.0.4.0
Oracle Developer Tools for Visual Studio .NET 10.1.0.4
Update: I reviewed my installation history and have the following:
I installed Oracle Express home on my c:drive and Oracle 10g home on my D: drive and I am using SQL Express 2005. So now I have the following:
Local XE version
C:\oraclexe\app\oracle\product\10.2.0\server (server?? - don't know why?)
Oracle.DataAccess.dll version 10.2.0.100
Local 10g version
Oracle.DataAccess.dll version 10.1.0.400