Roger,
Thank you v. much. This is exactly the info I was looking for.
Rgds,
Brien
-----Original Message-----
From: Roger Perttu
To: Brien Pirkle; '[EMAIL PROTECTED] '
Sent: 28/11/02 16:47
Subject: Re: Calling SQLServer Stored Procedures
Brien Pirkle wrote:
>Jeff,
>
>So, assuming sp_foo takes no paramters, my whole script could be:
>
>#####################
>use DBI;
> my $dbh = DBI->connect('DBI:ODBC:OSTDB', 'user', 'password')
> or die "Couldn't connect to database: " . DBI->errstr;
>
>{call sp_foo}
>
#More like this:
my $sth = $dbh->prepare('{call sp_foo}');
$sth->execute();
# or check up on do in the dbi docs
>
>
>#####################
>
>
>
>
CONFIDENTIALITY AND DISCLAIMER NOTICE
The information contained in this e-mail and any attachments
is confidential and intended for the addressee only and may
be protected by copyright. Copying or forwarding any part of
this e-mail is prohibited. If you have received this e-mail in
error please delete it and notify us by telephone or return
e-mail immediately. Any views or opinions contained in
this message are solely those of the sender and do not
necessarily represent those of Microgen-OST Limited.
We advise you to carry out your own virus check before
opening any attachments as we do not accept liability for
any damage sustained as a result of any software viruses.
Microgen-OST Limited registered address:
11, Park Street,
Windsor,
Berkshire
SL4 1LU
Company Registration No 3475849
