Discussions
Categories
- 385K All Categories
- 2.5K Data
- 580 Big Data Appliance
- 2K Data Science
- 452K Databases
- 222.3K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 574 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 575 SQLcl
- 4K SQL Developer Data Modeler
- 187.7K SQL & PL/SQL
- 21.5K SQL Developer
- 10 Data Integration
- 10 GoldenGate
- 297.6K Development
- 3 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 294.3K Development Tools
- 118 DevOps
- 3.1K QA/Testing
- 646.3K Java
- 30 Java Learning Subscription
- 37K Database Connectivity
- 185 Java Community Process
- 107 Java 25
- 22.1K Java APIs
- 138.3K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 172 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 575 LiveLabs
- 41 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 191 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 240 Portuguese
Unable to connect ORACLE11g using the oracle 11g driver from MS Access
Hi,
We have an MS Access application that connects to ORACLE to pull the data. We are using the ODBC based DSN to connect to the Oracle. As of now we are trying to configure the DSN using the ODBC driver 'Oracle in OraClient11g_Home1'. We configured the TSN successfully in the TSNNAMES.ORA in the ORACLE HOME directory. The TSN name is appearing in the DSN configuration window. But when I tried to Test the Connection it is failing. the ODBC error is thrown with error number M004. Anyone please help in resolving the issue. We have configured the ORACLE_HOME and TSN_ADMIN in the environment variables. Earliest help is appreciated.
Regards,
KALYAN
Answers
-
Also the error we are getting is "ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed".
The ORACLE 11g is lying on Unix. The MS ACCESS application is in Windows 2003 Server
-
Check if %ORACLE_HOME%\bin is in PATH environment variable. It may cause IM004 error on Windows.
-
We have tried this option, still we are getting the IM004 Error. The ORACLE_HOME is set and the required TNS configurations are done in the TNSNAMES.ORA.
The TNS Names are appearing in the List while trying to configure the DSN connection. But when we opt for the test connection, we are getting the IM004 error. If we remove the Oracle Home BIN reference in the environment variables we are getting IM003 error.
Is there any constraint with the connectivity to the UNIX based ORACLE from the Windows 2003 server.
Regards,
KALYAN
-
If you're using remote desktop session, you can try adding "Create Global Objects" privilege for remote desktop user in your server's local policy settings. That may resolve this issue.
Thanks & Regards,
Senthil