This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I did not get any solution yet . I am getting this oracle error while trying to read using Input Data function. (Error message attached)
I have installed Oracle ODBC driver for 64Bit for my laptop (it is a 64bit)
The table has been read using TOAD (user id /pwd is active)
I have tested the Oracle ODBC driver configuration in windows and DB connected successfully (Image attached)
Please check this article, it might be helpful for you to set up an Oracle connection.
Basicly I think you're not selecting the option to connect through ODBC. There are 3 ways of connecting to an Oracle Database - Client (OCI), ODBC and OleDB.
You're probably choosing through the Client (OCI), the error message indicates that
I am getting the following error using ODBC connection
Get Table List Error: Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
I am getting the same error using ODBC and OCI. Did you find a solution?