Re: MS SQL server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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. _______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos

[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux