Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 390 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
ODBC Call failed
Hi to All,
This is the "scenario".
- On server windows 2003 is installed Oracle DB 10gR2 32 bit with a database.
- On Client Windows 10 64 bit I have installed Oracle Client 12c 64 bit
- On this client I have created an User DSN and the connection Test is succefull.
Now I try to connect a new Access DB using External Link with the ODBC DNS created, but this message is displayed "ODBC: call failed"
Have You an idea?
Thank You and Best Regards
Answers
-
Hi,
Please check whether the installed MS Office (MS Access) is 32bit or 64bit version. It should be 64bit version in case Oracle Client 12c 64bit
Also please note that Windows 10 is not yet certified with RDBMS 12c.
Thanks & Regards,
Senthil
-
there may be blocking of ports over your firewall or security policies.
the odbc test is successfull mean the client side its ok
you are not able to get the data via the desired port due to policies constraints or due to improper configuration at server side.
This discussion has been closed.