We use a product called Vortex by Trifox (www.trifox.com). It works quite well here at UCLA (we had it connecting with SQL 7, and upgraded to SQL 2K, and everything runs/connects fine). Robert Amodeo /.r.\ On Mon, 9 Dec 2002, Darrell Cormier wrote:
Has anyone had any luck, via some free/opensource client, connecting to a M$ SQL Server 2000 database using Perl. I am running SuSE 8.0 and trying to connect to a Windoze 2000 server that is running M$ SQL Server 2000. I need to retrieve data using Perl. My company is currently in a "no money out" mode and so I must find a cost free solution.. I am not a sys admin, just a developer with my hands tied. The sys admins are clueless as to a solution. We currently have an earlier version of Sybase (11.9.2) but it will only connect to SQL Server versions prior to 2000. An upgrade to a version of Sybase that will access SQL 2000 is a $40K upgrade. We have also tried ODBC Socket Server but cannot get it to function. It will only allow for single column data sets for some odd reason. The sys admins also tried FreeTDS and could not get it to function on our systems. The data that I will need to retrieve is fairly large, with as many as 3.5 million rows of data. Any ideas or experiences are greatly appreciated.
TIA, Darrell Cormier
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com