Yesterday I went to watch movie based on recommendation of the readers on my Facebook page. If you think we only discuss SQL on facebook page, it is not correct. We discussion pretty much everything what DBA do in their daily life.
During the movie, someone recognized me from our blog photo. He changed his sit and while I was watching movie and asked couple of quick question. I understand it is a bad manner to talk in movie while others are watching but still answered him quickly. Let us call him Jatin.
Here is our conversation:
Jatin: Are you Pinal Dave?
Pinal: I guess so.
Pinal: I am.
Jatin: I have one SQL question?
Pinal: Sure – can we talk after the movie is over.
Jatin: This movie is boring any way.
Pinal: Hm… Some may like it too. Any way we should talk afterwords.
Jatin: Answer me when you can – how can I connect from Linux box to SQL Box?
Pinal: Oh… why do you want to do that?
Jatin: Now you are asking me question and prolonging the conversation – see you lost interest from this boring movie.
Pinal: Oh…I did… (silence)… you are correct. Let us talk after the movie.
Jatin: Nice blog by the way, I read it every day.
Well, that was it, after the movie was over – we all rushed outside and never connected. I never met Jatin afterwords, Infact, I do not know what is his real name. I wanted to answer his question and reason why he wanted to use Linux box to connect to SQL Server installed machine. Any way, Jatin if you are reading my blog everyday as you said, here is your answer. Please leave your answer in comment as well – do mention your real name and details so we can continue our conversation.
The Microsoft SQL Server ODBC Driver for Linux provides native connectivity from Linux to Microsoft SQL Server. The 64 bit version of the Microsoft SQL Server ODBC Driver for Linux provides robust data access to Microsoft SQL Server. It allows native C and C++ applications to leverage the standard ODBC API and connect to Microsoft SQL Server 2008 R2. Microsoft SQL Server ODBC Driver for Linux also comes with powerful tools – sqlcmd and bcp.
Reference: Pinal Dave (http://blog.SQLAuthority.com)