Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Perl > Perl Misc > Querying SQLServer from Perl on Unix

Reply
Thread Tools

Querying SQLServer from Perl on Unix

 
 
Yash
Guest
Posts: n/a
 
      12-10-2003
Hi,

Is there a way I can access an MS SQL Server2000 database running on a
Win2000 server, using Perl on HP-Unix? I want to execute plain SELECT
queries. Any pointers will be of great help.

Thanks
Yash
 
Reply With Quote
 
 
 
 
James Willmore
Guest
Posts: n/a
 
      12-10-2003
On 10 Dec 2003 05:56:17 -0800
http://www.velocityreviews.com/forums/(E-Mail Removed) (Yash) wrote:

> Is there a way I can access an MS SQL Server2000 database running on
> a Win2000 server, using Perl on HP-Unix? I want to execute plain
> SELECT queries. Any pointers will be of great help.



You need to use, on the HP box, an OBDC manager. unixODBC is a good
one, and iODBC is another. After installing the manager, you can then
use DBI and the DBD::ODBC driver in Perl script running on the HP box.

I have no experience with an HP platform, but this method *should*
work for you.

Another is to use DBD:roxy. You would need to install Perl on the
Windows box and set the appropriate ODBC DSN on the Windows box. So,
you would use DBI on the HP box to connect to the DBD:roxy running
on the Windows box.

Again, this *should* work for you.

HTH

--
Jim

Copyright notice: all code written by the author in this post is
released under the GPL. http://www.gnu.org/licenses/gpl.txt
for more information.

a fortune quote ...
Job Placement, n.: Telling your boss what he can do with your
job.
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
querying Active Directory via LDAP in perl joseph85750@yahoo.com Perl Misc 5 12-14-2008 10:16 PM
Upgrading ASP w/SQLserver 2000 to ASP.NET w/ SQLserver 2005 =?Utf-8?B?SmVmZnJleQ==?= ASP .Net 2 04-27-2007 03:33 PM
my own perl "dos->unix"/"unix->dos" Robert Wallace Perl Misc 7 01-22-2004 10:59 PM
#!perl instead of #!/usr/bin/perl on a Unix/Apache webserver joe Perl Misc 8 11-14-2003 10:58 AM
Perl Help - Windows Perl script accessing a Unix perl Script dpackwood Perl 3 09-30-2003 02:56 AM



Advertisments