connecting to oracle Database from workbench 5
Hi,
I'm new to Domo administration, I'm trying to connect to Oracle database(12c) to create Dataset in workbech 5 version and i'm facing an issue when trying to connect to oracle database.
1. In workbech under "ODBC Connection Provider Editor" I have selected driver "Microsoft ODBC for Oracle (32-bit)" to connect to Oracle DB and I encountered with following error.
"ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"
2. could you please point me in right direction to resolve the issue to connect to Oracle Db to create dataset in Workbech.
Thanks,
Hari
Comments
-
I found this on another user board:
Had the same error when hosting .asp website that was making a connection to an Oracle database using the ODBC driver on Windows 2016 server. Found the below steps on a site. Couldn’t paste the link so I copied the steps.
This can occur if you have an invalid or incorrect PATH variable. To check your PATH variable:
- Right-click My Computer
- Choose PROPERTIES | ADVANCED | ENVIRONMENT VARIABLES
- Locate the PATH variable and copy it"s contents to a text editor such as notepad
Once you have done this you should now look for the following:
- A missing semicolon between the different application paths. Each application path in the list should be separated by a semicolon.
- Look for spaces between the semicolon and the next application path. Remove any spaces.
- If you have more than one Oracle installation, make sure the latest version appears in the PATH before any older versions. If you have uninstalled older versions and references still exist in the PATH then remove them.
If the PATH appears fine then the issue may be rights related.
- Opened up Windows Explorer
- Navigated to Oracle | ora92
- Right clicked and selected properties
- Clicked on Securities tab
- Clicked on Authenticated Users
- Unchecked Read and Execute | Click Apply
- Rechecked Read and Execute | Click Apply
- Clicked ok to close window
- Restart server
Hope that helps
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive