Connecting to M$ SQL 2000 via Perl?
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
Hello, I have not tried connecting with Perl but with PHP and the conection seem to work fine when using freetds - look for it from http://freshmeat.net, install it, read the simple INSTALL file, and you should be connected in no time at all. Any questions/troubles? Let the list/me know. I think there is a solution for your headache. Cheers, --jq 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
On Mon, 09 Dec 2002 12:22:14 -0600 Darrell Cormier <linuxdev@sptc.net> wrote:
Has anyone had any luck, via some free/opensource client, connecting to a M$ SQL Server 2000 database 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
Here's a start: http://www.algonet.se/~sommar/mssql/unix.html I did a search for "SQL Server 2000 perl" at http://groups.google.com and got alot of hits. You might want to go to http://perlmonks.org and post the question. If it can be done, someone there will point the way. -- use Perl; #powerful programmable prestidigitation
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
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
participants (5)
-
Darrell Cormier -
Gregory Sawyer -
Jyry Kuukkanen -
Robert Amodeo -
zentara