February 9th, 2004, 03:52 AM
unix apache ODBC to MS SQL
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?