I need to access a database on a MS SQL Sever from my unix apache web server.

I would preferably want to continue to use ASP rather than go to PHP or Perl - I know that I need to build unixODBC on the web box, but do I need to do anything else other than reference the SQL server in unixODBC?

Has anyone used unixODBC? The console & CLI seem fairly self-explanatory... Do you need extra drivers to connect to a MS SQL box?
Can I still use the same server.createobject & ADODB statements in my ASP code? Or do they need to change? Syntax etc?

Any pointers?

Cheers guys..

Andy T