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.. Any suggestions gratefully received and would be pleased to read the nice manual (if one is identified!). Tony
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.. > > Any suggestions gratefully received and would be pleased to > read the nice > manual (if one is identified!).You could try the Sybase libraries as both speak Transact-SQL and sprang from the same code base at one point. -Ross ______________________________________________________________________ This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution or copying of this e-mail, and any attachments thereto, is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender and permanently delete the original and any copy or printout thereof.
Php. I've written a few shell scripts in php before that do db tasks. Then there's also java. Geoff Sent from my BlackBerry wireless handheld. -----Original Message----- From: "Tony Barratt" <tbarratt at mibtree.com> Date: Sat, 15 Sep 2007 00:28:51 To:<centos at centos.org> Subject: [CentOS] MS SQL server 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.. Any suggestions gratefully received and would be pleased to read the nice manual (if one is identified!). Tony _______________________________________________ CentOS mailing list CentOS at centos.org http://lists.centos.org/mailman/listinfo/centos
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.
In article <003201c7f727$07b9c9b0$0300a8c0 at Laptop>, Tony Barratt <tbarratt at mibtree.com> 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.. > > Any suggestions gratefully received and would be pleased to read the nice > manual (if one is identified!).Have a look for the packages FreeTDS and sqsh. Cheers Tony -- Tony Mountifield Work: tony at softins.co.uk - http://www.softins.co.uk Play: tony at mountifield.org - http://tony.mountifield.org