[CentOS] MS SQL server

Fri Sep 14 23:41:13 UTC 2007
John R Pierce <pierce at hogranch.com>

Tony Barratt wrote:
> Hello List,
> I need to access some data a MS-SQL server ie run a stored procedure 
> or user-defined function or a select every so often maybe 3 times a day.
> Have centos 4.5 on intel xeon. Is there an obvious certain-to-succeed 
> approach?
> perl DBI + ODBC spings to mind, have not tried it yet - cannot access 
> the systems yet - need to make a good plan.
> Am a bit concerned cos I dont know of an alternative to perl DBI + 
> ODBC and I have heard a few anecdotes about how ODBC possibly 
> problematic..

in bizarro world, you could write your data access calls in middleware 
ASP code on the windows server, and call those procedures with a http 
GET from your perl.

there's some strange attractions to this methodology.     it greatly 
simplifies access control to the MS SQL, the perl -> windows interface 
is confined to very simple and well understood http, the windows guys 
can audit your SQL code in their comfort zone.