Re: Request for DBD::MS SQL

2007-05-15 Thread David Dick
Try DBD::Sybase. Sybase and SQL Server have a common ancestry and use the same TDS protocol. Ankit Mehrotra wrote: Dear All , I intend to remotely query Microsoft SQL Server (MS SQL) using Perl DBI module. The problems I am facing are : 1. The is no Driver available for MS SQL . 2. The

SV: Request for DBD::MS SQL

2007-05-15 Thread Henrik Schak Hansen
Use the DBD-ODBC package for connecting to MS SQL under windows. /henrik -Oprindelig meddelelse- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] På vegne af David Dick Sendt: 15. maj 2007 14:01 Til: Ankit Mehrotra Cc: perl-win32-users@listserv.activestate.com Emne: Re: Request for

Re: Request for DBD::MS SQL

2007-05-15 Thread Huub Peters
I did this with DBD::ODBC. Here's a connection example: == use DBI; my $dbname = 'database_name'; my $dbhost = '192.168.1.100'; my $dbuser = 'username'; my $dbpass = 'password'; my $dbh = DBI-connect(DBI:ODBC:driver=SQL

How do I know where my Perl script is running?

2007-05-15 Thread John Townsend
Here's my situation: My script is executed by a larger system, from some abitrary directory. How can I tell from which directory my Perl script was executed? I guess I'm looking for something like pwd from UNIX. ___ Perl-Win32-Users mailing list

RE: How do I know where my Perl script is running?

2007-05-15 Thread Hoopes, William @ CSE
Would this work for you? http://www.perl.com/doc/manual/html/lib/Cwd.html From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Townsend Sent: Tuesday, May 15, 2007 11:33 AM To: perl-win32-users@listserv.ActiveState.com Subject: How do I

RE: How do I know where my Perl script is running?

2007-05-15 Thread Wagner, David --- Senior Programmer Analyst --- WGO
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Townsend Sent: Tuesday, May 15, 2007 08:33 To: perl-win32-users@listserv.ActiveState.com Subject: How do I know where my Perl script is running?

RE: How do I know where my Perl script is running?

2007-05-15 Thread Andy_Bach
2 ways of looking at your quesiton: FindBin: NAME FindBin - Locate directory of original perl script SYNOPSIS use FindBin; use lib $FindBin::Bin/../lib; or use FindBin qw($Bin); use lib $Bin/../lib; give you where the script itself is. The

File attachments via Perl using Net::SMTP

2007-05-15 Thread Dax Games
Is it possible to send SMTP mail with file attachments via Net::SMTP? if not how can I do this. I am sending SMTP messages successfully but need to send an attached text file as well. Thanks, Dax ___ Perl-Win32-Users mailing list

Re: File attachments via Perl using Net::SMTP

2007-05-15 Thread Mark Dootson
You need MIME::Lite; Dax Games wrote: Is it possible to send SMTP mail with file attachments via Net::SMTP? if not how can I do this. I am sending SMTP messages successfully but need to send an attached text file as well. Thanks, Dax ___

RE: File attachments via Perl using Net::SMTP

2007-05-15 Thread Mark Funk
Yes it is possible. This is how I have done it in the past... try this... . . . use MIME::Lite; use Net::SMTP; ### Adjust sender, recipient and your SMTP mailhost my $from_address = 'Me'; my $to_address = $email_addy; my $mail_host = $mail_host; ### Adjust subject and body

Re[2]: Win32::Tie::Ini for Perl 5.8?

2007-05-15 Thread Dax T. Games
I switched to using Config::IniFiles. It is very similar and seems to work very well and it is available. Thanks for all the responses. Dax *** REPLY SEPARATOR *** On 5/14/2007 at 10:43 PM Jack D wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: How do I know where my Perl script is running?

2007-05-15 Thread Sisyphus
- Original Message - From: Wagner, David --- Senior Programmer Analyst --- WGO [EMAIL PROTECTED] $0 holds the name of the file executing your script. It appears as fully qualified name. I don't think the cwd will give you what you want as regards the script being executed. ( In

Re: How do I know where my Perl script is running?

2007-05-15 Thread Bill Luebkert
Sisyphus wrote: - Original Message - From: Wagner, David --- Senior Programmer Analyst --- WGO [EMAIL PROTECTED] $0 holds the name of the file executing your script. It appears as fully qualified name. No it doesn't. It may or may not be fully qualified. I don't think