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.