SQLGetPrivateProfileString failed with

command-line odbc dsn rhel6
Kapil Vyas picture Kapil Vyas · Dec 14, 2012 · Viewed 16.5k times · Source

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

Answer

Kapil Vyas picture Kapil Vyas · Dec 17, 2012

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!

Related questions

How to create User DSN for *.accdb from commandline in Windows?

I work in an environment where DSN-Less connection is not possible due to some restrictions. I need to create User DSN for "Microsoft Access Driver (*.mdb,*.accdb)". the .accdb file is located in local disk. I have tried C:\>…

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How do I copy a folder from remote to local using scp?

How do I copy a folder from remote to local host using scp? I use ssh to log in my server. Then, I would like to copy the remote folder foo to local /home/user/Desktop. How do I achieve …

Read More