SQLGetPrivateProfileString failed with

问题:

Typing the command: odbcinst -q -s on RHEL 6, I get the following error message:

odbcinst: SQLGetPrivateProfileString failed with .

All my DSN's are also not showing up when I run:

odbcinst -q -d

回答1:

Type the command: env |grep 'ODBC' to check if the ODBCSYSINI and the ODBCINI variables are set. If no results are returned - you need to add the variables to the environment variable pointing to the directory and the path to where the odbc.ini file is located as follows (in my case for RHEL 6 it is located at /etc - others may have it on /usr/local/etc):

Edit ~\.bash_profile and add the following lines:

export ODBCSYSINI=/etc
export ODBCINI=/etc/odbc.ini

You are good to go!

回答2:

Its too late to answer on this question probably, but it is for those who still couldn't get this resolved using @kapil Vyas answer-

Adding to his answer, you will need to logout and then login again from your user for export commands (saved in .bash_profile) to work.

回答3:

In my case (ubuntu 16.04) it was related to this bug, just not ~/.odbc.ini but /etc/odbc.ini. Adding a line to /etc/odbc.ini

[empty-sys]

fixed the problem.

回答4:

When I had this problem, I edited /usr/local/etc/odbcinst.ini to add:

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc8a.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
FileUsage = 1
Pooling = Yes
CPTimeout = 120

I hope this is helpful.