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.