Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.9K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.5K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.2K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 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
- 402 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
Trouble trying to install ODBC driver 12.2 on MAC

I've been having a really hard time trying to install the ODBC driver on mac, i followed several instructions, for example these two:
- https://community.oracle.com/thread/4120787
- https://blogs.oracle.com/opal/installing-the-oracle-odbc-driver-on-macos
And i just can't make it work. I have been searching tutorials on a bunch of sites: stackoverflow, youtube, etc but i just can't make it work.
About the blog link: when trying to run the following statement
sudo odbc_update_ini.sh /usr/local
I got the following error:
sudo: odbc_update_ini.sh: command not found
So i just used
sudo sh odbc_update.ini.sh /usr/local
And got:
*** ODBCINI environment variable not set,defaulting it to HOME directory! *** ODBCINI environment variable not set,defaulting it to HOME directory!
No idea what that means honestly.
Lastly i tried connecting to the database through isql on the terminal as follows:
isql OracleODBC-12c dsn user password | isql OracleODBC-12c user password
and it doesn't work .
Please help me, i'm kind of freaking out.
Thanks in advance!
Answers
-
You have missed to prefix the path './'.
You need to execute it as:
sudo ./odbc_update.ini.sh /usr/local
What is the error message displayed by isql?
Have you checked whether the TNS setting using SQL*Plus? Were you able to connect to database using SQL*Plus?
-
Ok, so i executed:
sudo ./odbc_update.ini.sh /usr/local
And i got the same message:
*** ODBCINI environment variable not set,defaulting it to HOME directory!
Can you tell what does that mean?
When i try:
isql OracleODBC-12c user pwd
i get [ISQL]ERROR: Could not SQLConnect
I did sudo nano ~./odbc.ini and changed the following parts:
ServerName=
to
ServerName=localhost/myservicename
i'm trying to connect to a local server using ethernet connection on a lan.
UserID=
to UserID=myuserid
Thanks so much for you help!
-
> *** ODBCINI environment variable not set,defaulting it to HOME directory!
It says that the .odbc.ini is created in the default path (i.e. $HOME directory).
> ServerName=localhost/myservicename
If the DB server is not running in the default port 1521, you need to specify the port number too. Best way to troubleshoot this scenario is by using SQL*Plus to cross the connectivity with the TNS information provided in 'ServerName' attribute in ~/.odbc.ini file.
-
I tried
isql -v localhost:1521/TNSName user pwd
and i got
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
I suppose it's an advance?
-
Hey, I'm in the same error now, any update?
-
We shouldn't be passing the Oracle ez connection string in unixODBC isql.utility.
Proper syntax for unixODBC isql is :
<strong>isql</strong> <em>DSN</em> [<em>USER</em> [<em>PASSWORD</em>]] [<em>options</em>]