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.
Ross S. W. Walker wrote:
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.
It's a little dated, but you might find up-to-date versions of some of the libraries and utilities mentioned in this article:
http://linuxgazette.net/issue18/sybase.html
-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@mibtree.com
Date: Sat, 15 Sep 2007 00:28:51 To:centos@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@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@Laptop, Tony Barratt tbarratt@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
-
gjgowey＠tmo.blackberry.net -
John R Pierce -
Ross S. W. Walker -
Tony Barratt -
tony＠softins.clara.co.uk