Unable to connect to Oracle 10g Express Edition with ODBC

c oracle odbc oracle-xe
A.J. picture A.J. · Feb 11, 2009 · Viewed 9.2k times · Source

I am using C to write a DLL that provides basic database connection functionality to a couple of different applications, using ODBC. When I use this DLL to connect to an Oracle database (Oracle 10g Express Edition, specifically) I get the following error message:

Specified driver could not be loaded due to system error 1114 (Oracle in XE).

After rebooting my computer, one of the applications that uses this DLL can connect to the database, but the other (more important one) still gets this message.

Does anyone know what may be causing this error and how I can fix it? I've never used Oracle before so I don't really know where to start to fix this problem. Thanks in advance for any ideas anyone out there can give.

EDIT: I checked the PATH environment variable. It begins with: C:\oraclexe\app\oracle\product\10.2.0\server\bin. That's the correct path to Oracle on my computer.

Answer

DCookie picture DCookie · Feb 11, 2009
  1. Setup the windows PATH to first search the ORACLE_HOME\bin related to the Oracle ODBC Driver you're trying to use, or start your application in the ORACLE_HOME\bin directory related to the ODBC driver.
  2. Make sure the version of the ODBC driver matches the version of SQL*Net you have installed.

Related questions

How do I connect to a database using Pro*C?

As the title says, how do I connect to a given database in Oracle's Pro C? I don't want the connection for Oracle database but for some other database.

Read More
What is pro *c?

How is that useful? How can we access data from the database?

Read More
How do I determine the size of my array in C?

How do I determine the size of my array in C? That is, the number of elements the array can hold?

Read More