Perl and MS SQL Server Stroed Procedures

[Fresh Air Rider]

Hi Folks

Could someone kindly please give me an example of the correct syntax
for generating a recordset by calling a SQL Server stored procedure
with an input paramter via Perl / PerlScript ?

I have searched extensively on the internet and cannot find it
anywhere.

I'm confused about whether to use Win32::ODBC, ADO, DBD, DBI etc etc

It sounds so simple and I cannot believe how difficult it is to find
information on this.

Thanks
John

[Nicholas Dronen]

Fresh Air Rider <Fresh_Air_Rider@hotmail.com> wrote:
FAR> Hi Folks

FAR> Could someone kindly please give me an example of the correct syntax
FAR> for generating a recordset by calling a SQL Server stored procedure
FAR> with an input paramter via Perl / PerlScript ?

FAR> I have searched extensively on the internet and cannot find it
FAR> anywhere.

FAR> I'm confused about whether to use Win32::ODBC, ADO, DBD, DBI etc etc

FAR> It sounds so simple and I cannot believe how difficult it is to find
FAR> information on this.

Have you looked at the Win32::ODBC and DBI documentation on

[url]http://www.cpan.org/[/url]

Regards,

Nicholas


--
"Why shouldn't I top-post?" [url]http://www.aglami.com/tpfaq.html[/url]
"Meanings are another story." [url]http://www.ifas.org/wa/glossolalia.html[/url]

[cp]

In article <556722cb.0306261217.3cfd9d99@posting.google.com >, Fresh Air
Rider <Fresh_Air_Rider@Hotmail.com> wrote:

> Could someone kindly please give me an example of the correct syntax
> for generating a recordset by calling a SQL Server stored procedure
> with an input paramter via Perl / PerlScript ?
>
> I have searched extensively on the internet and cannot find it
> anywhere.
>
> I'm confused about whether to use Win32::ODBC, ADO, DBD, DBI etc etc
>
> It sounds so simple and I cannot believe how difficult it is to find
> information on this.

Perhaps the DBI docs at [url]http://dbi.perl.org/[/url] can help. Or, if you want
to by pass DBI calls, and you have IIS running on the MS SQL server,
you can post XML or SOAP queried to the MS SQL server directly. Modules
like XMLL::Parser, XML::Twig or XML::Simple can help with that. I found
all I need to set up an XML query in the books online that Query
Analyzer installed. YMMV.

If you're using Perl's DBI, stored procedures can be called with the
'do' method.

There is always a search of the newsgroups at Google.
[url]http://groups.google.com/[/url]. I found over a hundred articles with a
cursory search.

--
cp

[Fresh Air Rider]

Thanks CP I'll have a look at that.

Many thanks
John