[Za-pm] perl -> MS SQLserver

[Werner Moller]

I'm going to try this right now! Do you do inserts as well?
 
Cheers,
Werner

-----Original Message-----
From: Spike [mailto:spikeh at mweb.co.za]
Sent: 27 June 2003 12:31
To: Za-pm at mail.pm.org
Subject: Re: [Za-pm] perl -> MS SQLserver


All working fine!

M$ SQL is a pain but I now have a perl script on my LINUX box that queries a
MS SQLservr 2000 database onon an NT box.

I am useing the Sybase::DBD module which happily talks to MS via the TDS
protocol with no ODBC cluients in the way to complicate and slow things
down.

Hell - I think I shall have the rest of the day off

Thanks Oscar for the pointer to freetds.org 


At 2003/06/26 12:44 PM, Oskar Pearson wrote:


Hi


> It's not the best software on earth, by the way - do some
> extensive testing to ensure it's not giving you bogus results;
> I've had problems with, for example, very very large numbers
> being fed back wrong.

Sorry to reply to my own reply. Just a note that the above was
with freetds 0.53-7 - I don't know if later versions are
better.

http://www.freetds.org/ <http://www.freetds.org/> 

Latest version is 0.61.

The numbers were numeric(18,0)s, if I remember correctly.

Oskar
--
Oskar Pearson <oskar at qualica.com>
Qualica Technologies (Pty) Ltd
web: http://www.qualica.com/ <http://www.qualica.com/>  


Spike Hodge

UNIX Programmer
M-Web Technology
021 596 8496
082 901 5265

Click here and make M-Web your homepage
http://homepage.mweb.co.za <http://homepage.mweb.co.za/>  

  _____  

This e-mail message has been scanned for Viruses and Content and cleared by
Ifusion's MailMarshal Gateway 
  _____  



#####################################################################################
Note:
This message is for the named person's use only.  It may contain confidential,
proprietary or legally privileged information.  No confidentiality or privilege
is waived or lost by any mistransmission.  If you receive this message in error,
please immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender.  You must not, directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if you are not
the intended recipient. IFusion (PTY) Ltd and any of its subsidiaries each reserve
the right to monitor all e-mail communications through its networks.

Any views expressed in this message are those of the individual sender, except where
the message states otherwise and the sender is authorized to state them to be the
views of any such entity.

Thank You.
#####################################################################################
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.pm.org/pipermail/za-pm/attachments/20030703/342a0454/attachment.htm