Originally posted by: TechStudent36

Hello aix community,

After scouring the internet to find a step by step process, I've exhausted my efforts. Although I have learned a lot which brings me to this forum. I'm totally new and hope to ask the right questions.

What is the easiest way to connect to a SQL server from aix?

Researching out there, it seems that there are a couple of options:

Data Direct driver
FreeTDS
unixODBC

I hope someone here in the community can either point me in the right direction or share with me some resources and even a step by step if they have one

What am I'm trying to do?
Where I work, we use aix as our main os. We also have a SQL server that houses a lot of our data. 

All I want to do is create an aix query that will allow me to connect to a SQL server. From that connection, I want to create an ODBC connect that will allow me to read a dbo table and then create a file with my criteria.

How can you help?
1. High level view of the sequence of steps I need to take to install a driver on aix and probably something on the SQL server side that will allow me to connect to a SQL server. What driver should I use to connect the two?

Thanks in advance for your help!
TechStudent36