C program access to MSSQL database

I need to write a C program on UNIX that will access an MSSQL database (NOT C++, NOT C#, NOT Visual C). Is this possible? (yes/no) Now, if you could oblige me; can you point me in the web direction where i can find out how to do this?Hi there,

Yes this is indeed possible. I have no real acquaintance with this myself, but from things I have read it is indeed possible. If you are using the C programming language, I believe the only option for you is to use ODBC.

You will probably need to download certain components for this to work because, as far as I'm aware, standard UNIX does not include ODBC (been a while since I checked though). Anyway, chances are you will need to download things (like an ODBC driver and an ODBC driver manager).

Here is a couple of tutorials on how to use ODBC from C on UNIX to connect to a database hosted on something like SQL Server. These tutorials also contain links to downloads so that you can get an ODBC driver and ODBC driver manager:

Tutorial Part 1
Tutorial Part 2

In case those aren't enough, throughout my travels I remember seeing other tutorials related to using C and ODBC on UNIX. I don't remember what they are at the moment (too long ago) but they should be available if you search for them (e.g. through Google). Use terms like UNIX, ODBC and SQL Server and you should get some links that point you in the right direction.

Hope that gives you enough help to set you on your way,