- 3,734,268 Users
- 2,246,935 Discussions
- 7,857,216 Comments
Forum Stats
Discussions
Howdy, Stranger!
Categories
- 380.9K All Categories
- 2.1K Data
- 203 Big Data Appliance
- 1.9K Data Science
- 446.1K Databases
- 220.4K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 23 Multilingual Engine
- 506 MySQL Community Space
- 459 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 438 SQLcl
- 3.9K SQL Developer Data Modeler
- 185.4K SQL & PL/SQL
- 20.8K SQL Developer
- 291.3K Development
- 6 Developer Projects
- 117 Programming Languages
- 288.1K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.2K Java
- 18 Java Learning Subscription
- 36.9K Database Connectivity
- 149 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.7K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 12 Java Essentials
- 138 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
- 195 Java User Groups
- 22 JavaScript - Nashorn
- Programs
- 180 LiveLabs
- 34 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 165 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 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>]