[26228] in Perl-Users-Digest
Perl-Users Digest, Issue: 8413 Volume: 10
daemon@ATHENA.MIT.EDU (Perl-Users Digest)
Tue Sep 13 18:05:16 2005
Date: Tue, 13 Sep 2005 15:05:06 -0700 (PDT)
From: Perl-Users Digest <Perl-Users-Request@ruby.OCE.ORST.EDU>
To: Perl-Users@ruby.OCE.ORST.EDU (Perl-Users Digest)
Perl-Users Digest Tue, 13 Sep 2005 Volume: 10 Number: 8413
Today's topics:
[OT] connecting to MS SQL on a different computer (DBD: <john@castleamber.com>
Re: [OT] connecting to MS SQL on a different computer ( <1usa@llenroc.ude.invalid>
Re: File::Copy works, File::NCopy doesn't <1usa@llenroc.ude.invalid>
Digest Administrivia (Last modified: 6 Apr 01) (Perl-Users-Digest Admin)
----------------------------------------------------------------------
Date: 13 Sep 2005 20:36:49 GMT
From: John Bokma <john@castleamber.com>
Subject: [OT] connecting to MS SQL on a different computer (DBD::ODBC)
Message-Id: <Xns96D09EB37CA41castleamber@130.133.1.4>
Can anyone give pointer(s) on how to connect to a server which runs MS SQL
using DBD::ODBC? I thought it would be as simple as specifying a host and
port, but I can't seem to get it working, and been googling for quite some
time and not found any solution yet and I am a bit lost in UNC, DNC and
more 3 letter abbreviations :-(
--
John Small Perl scripts: http://johnbokma.com/perl/
Perl programmer available: http://castleamber.com/
Happy Customers: http://castleamber.com/testimonials.html
------------------------------
Date: Tue, 13 Sep 2005 21:32:03 GMT
From: "A. Sinan Unur" <1usa@llenroc.ude.invalid>
Subject: Re: [OT] connecting to MS SQL on a different computer (DBD::ODBC)
Message-Id: <Xns96D0B25EC2433asu1cornelledu@127.0.0.1>
John Bokma <john@castleamber.com> wrote in
news:Xns96D09EB37CA41castleamber@130.133.1.4:
> Can anyone give pointer(s) on how to connect to a server which runs MS
> SQL using DBD::ODBC? I thought it would be as simple as specifying a
> host and port, but I can't seem to get it working, and been googling
> for quite some time and not found any solution yet and I am a bit lost
> in UNC, DNC and more 3 letter abbreviations :-(
From <URL: http://search.cpan.org/~jurl/DBD-ODBC-1.13/ODBC.pm>:
use DBI;
$dbh = DBI->connect('dbi:ODBC:DSN', 'user', 'password')
That would indicate that you need to configure a DSN for the server you
want to access from the Control Panel on the machine from which you want
to access.
Sorry, my knowledge and understanding of ODBC ends there.
Sinan
--
A. Sinan Unur <1usa@llenroc.ude.invalid>
(reverse each component and remove .invalid for email address)
comp.lang.perl.misc guidelines on the WWW:
http://mail.augustmail.com/~tadmc/clpmisc/clpmisc_guidelines.html
------------------------------
Date: Tue, 13 Sep 2005 21:56:20 GMT
From: "A. Sinan Unur" <1usa@llenroc.ude.invalid>
Subject: Re: File::Copy works, File::NCopy doesn't
Message-Id: <Xns96D0B67CEB50Dasu1cornelledu@127.0.0.1>
Christopher Benson-Manica <ataru@nospam.cyberspace.org> wrote in
news:dg6lpu$oh$1@chessie.cirr.com:
> I have a situation where I invoke File::Copy and File::NCopy with
> identical arguments - I am attempting to copy a file from one network
> path to another, something like
>
> copy( "\\\\$somepath\\foo\\bar.txt",
> "\\\\$someotherpath\\foo\\bar.txt" );
>
> File::Copy works fine, but File::NCopy says "No such file or
> directory". Can NCopy's copy not handle network paths? (This is
> ActiveState Perl 5.8.7 for WinXP).
I don't know anything about File::NCopy, but did you try enabling debug
mode?
my $fcopy = File::NCopy('_debug' => 1);
$fcopy->copy( ... );
On the other hand, I do not find it encouraging that the module author
uses print for debug messages. He should be using warn.
Sinan
--
A. Sinan Unur <1usa@llenroc.ude.invalid>
(reverse each component and remove .invalid for email address)
comp.lang.perl.misc guidelines on the WWW:
http://mail.augustmail.com/~tadmc/clpmisc/clpmisc_guidelines.html
------------------------------
Date: 6 Apr 2001 21:33:47 GMT (Last modified)
From: Perl-Users-Request@ruby.oce.orst.edu (Perl-Users-Digest Admin)
Subject: Digest Administrivia (Last modified: 6 Apr 01)
Message-Id: <null>
Administrivia:
#The Perl-Users Digest is a retransmission of the USENET newsgroup
#comp.lang.perl.misc. For subscription or unsubscription requests, send
#the single line:
#
# subscribe perl-users
#or:
# unsubscribe perl-users
#
#to almanac@ruby.oce.orst.edu.
NOTE: due to the current flood of worm email banging on ruby, the smtp
server on ruby has been shut off until further notice.
To submit articles to comp.lang.perl.announce, send your article to
clpa@perl.com.
#To request back copies (available for a week or so), send your request
#to almanac@ruby.oce.orst.edu with the command "send perl-users x.y",
#where x is the volume number and y is the issue number.
#For other requests pertaining to the digest, send mail to
#perl-users-request@ruby.oce.orst.edu. Do not waste your time or mine
#sending perl questions to the -request address, I don't have time to
#answer them even if I did know the answer.
------------------------------
End of Perl-Users Digest V10 Issue 8413
***************************************
