How to connect to sql server from cygwin

newuser85 · 10-16-2015, 11:32 AM

Hi,

I want to connect to my sql server server on windows machine from Cygwin using shell script. for that whether we want to install any third party tool to connect to the sql server from shell script. Please advice.

Thanks in advance.

berndbausch · 10-16-2015, 04:51 PM

Quote:

Originally Posted by newuser85

Hi,

I want to connect to my sql server server on windows machine from Cygwin using shell script. for that whether we want to install any third party tool to connect to the sql server from shell script. Please advice.

Cygwin has a mysql client https://cygwin.com/cgi-bin2/package-....45-1&grep=sql.

newuser85 · 10-18-2015, 06:49 AM

Hi,

Thanks for your reply. I would like to test the database connection with the microsoft sql server from within the script. It would be a great help if someone can give the syntax to test connect the microsoft server.

thanks.

pan64 · 10-18-2015, 08:14 AM

the shell (bash) itself cannot connect to any database, you need to use another language (python, perl, java ...). All of them have database drivers, you need to install that and read the documentation on how to connect.