On my laptop I have successfully installed both XE 11.2.0.2.1 and SQL Developer 4.0.1.
TNSNAMES.ORA is correctly configured, so both SQLPlus and SQL Developer have access to the database, I can create tablespaces, users, tables, etc. SQLDeveloper connects using TNSNAMES.ORA.
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PORTLEKU)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
FITTING_SERVICE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PORTLEKU)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
However, when I run my application program, "Fitting.EXE", it gives me a failure message "Class not registered" when I execute Connection.DoConnect.
The connection string is configured to connect by OLE DB, using Fitting_Service as the data source. This is known to work, as the program works correctly on my desktop PC which runs Oracle 10g with OLE DB, and is used to compile and link the executable (The laptop has no development software).
My first thoughts on this problem are as follows:
1) I need ODAC on the laptop. But that creates a new Oracle Home, doesn't it ?? So if I configure the TNSNAMES.ORA in that new folder tree, how can it reach the database server on that same PC, a server which already has a listener configured, and known to be working as SQLDeveloper can see the database. There is already a TNSNAMES.ORA file in the server folder tree, and correctly configured. If I install a new listener, won't it somehow override the existing one, maybe breaking the connection that SQLDeveloper uses ???
2) The Fitting.EXE program was linked on a system with 10g, and the corresponding OLE DB software. Maybe it cannot connect to an 11g database, or through an 11g OLE DB if I install it from ODAC 11.2.0.2.1 ??? I have not yet tried installing ODAC as I was afraid of upsetting something that already works -- see 1) above.
As you can probably guess I'm a bit lost on this, and need someone to point me in the right direction instead of groping around in the dark.
--
JF