Test ODBC entry on Unix

linux unix odbc
Diego picture Diego · Mar 30, 2012 · Viewed 38.5k times · Source

Does anyone know a way of testing if an odbc entry on the odbc.ini file is configured correctly?

I would like to know if my linux server is able to connect to my SQL Server using an ODBC entry I configured.

Answer

bohica picture bohica · Mar 30, 2012

If you are using unixODBC as the ODBC driver manager then just do:

isql -v mydsn myusername mypassword

Related questions

Looping through the content of a file in Bash

How do I iterate through each line of a text file with Bash? With this script: echo "Start!" for p in (peptides.txt) do echo "${p}" done I get this output on the screen: Start! ./runPep.sh: line 3: syntax error …

Read More
How to permanently set $PATH on Linux/Unix?

I'm trying to add a directory to my path so it will always be in my Linux path. I've tried: export PATH=$PATH:/path/to/dir This works, however each time I exit the terminal and start a new terminal …

Read More
How do I grep recursively?

How do I recursively grep all directories and subdirectories? find . | xargs grep "texthere" *

Read More