Re: Are There any Free Tools to do Remote SQL Queries?

2002-12-18 Thread Martin McCormick
My sincerest thanks to everyone who responded to my
question.  All of you sent a wide range of good suggestions of
which we went the PHP route although one never knows when this
will arise again so I will keep all the answers on file.

To Unsubscribe: send mail to [EMAIL PROTECTED]
with unsubscribe freebsd-questions in the body of the message



RE: Are There any Free Tools to do Remote SQL Queries?

2002-12-17 Thread Barry Byrne
Martin:

Haven't needed to try it myself, but how about a Perl DBI/DBD solution?

 - Barry

--
Barry Byrne, IT Manager,
WBT Systems, Block 2, Harcourt Centre
Harcourt Street, Dublin 2, Ireland


 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Martin
 McCormick

   We may need to make sql queries to a Microsoft server
 from a FreeBSD system.  I am in an area of which I am totally
 unfamiliar and there is a bit of a time factor involved.
 
   The object is to retrieve text files containing the
 results of the query so that scripts can be generated based upon
 the information.  That, I can handle.  The problem is in figuring
 out the best way to access the MS server from here.


To Unsubscribe: send mail to [EMAIL PROTECTED]
with unsubscribe freebsd-questions in the body of the message



Re: Are There any Free Tools to do Remote SQL Queries?

2002-12-17 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2002-12-17 11:08:17 -0600:
   We may need to make sql queries to a Microsoft server
 from a FreeBSD system.  I am in an area of which I am totally
 unfamiliar and there is a bit of a time factor involved.
 
   The object is to retrieve text files containing the
 results of the query so that scripts can be generated based upon
 the information.  That, I can handle.  The problem is in figuring
 out the best way to access the MS server from here.

roman@freepuppy ~ 1008:0  cat /usr/ports/databases/freetds/pkg-descr 
This is TDS protocol library (CTlib/DBlib) that is used to connect to
Microsoft and Sybase SQL servers. This can be used instead of native
libraries, that are shipped with commercial products.

WWW: http://www.freetds.org/
roman@freepuppy ~ 1009:0  

-- 
If you cc me or remove the list(s) completely I'll most likely ignore
your message.see http://www.eyrie.org./~eagle/faqs/questions.html

To Unsubscribe: send mail to [EMAIL PROTECTED]
with unsubscribe freebsd-questions in the body of the message