On Monday 09 December 2002 10:22, 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
I have heard that Michael Peppler's Sybperl can connect to M$ SQL Servers, though I'm not sure if there are any version restrictions. If you have Sybperl to get access to ASE, it may even "Just Work" At any rate, I would take a gander at Peppler's home page, which can be found at: www.mbay.net/~mpeppler That would be a good place to start. Later, --Gregory