netniV

I suspect that if you did a sudo -E obdcinst -j it would be failing too because your current environment is missing something that has been installed and when using SUDO it creates a new environment unless you use the -E option.

OK, have you tried completely logging out and back in again? It sounds like an environment setting isn't present.

Can you do "who am i" not "whoami" ? Also can you do "echo $HOME"?

can you run, "who am i"?

OK, then you ARE running as two different users. The user you are currently in, and the user when you sudo. Try sudo cat ~/.odbc.ini

OK, two things, what command are you using to make the connection? Secondly, there was no [ODBC Data Sources] section in the above ODBC.INI file which there should be.

What are the contents of your ODBC.INI files? Redact any sensitive info such as usernames/passwords

Is root the user you are running the connection as? Or is it via a web page?

I've updated my answer with more detail now that I've researched it a bit more.

No worries. Heading to work in a moment so I’ll take a look once Im there

I would add the contents of your /etc/odbcinst.ini too. As there can be different driver libraries involved.