
ODBC, SQL Server, Stored Procedures
To anyone who can answer this,
I'm using Perl on the server side to search and interact with a
database through ODBC in the Win 32 environment. I've run into a wall
in figuring out how to call the SQL server stored procedures through
ODBC and through Perl. I have used the WIN32::ODBC moduled to run SQL
queries, but what I need to do involves some complex data manipulations
and would, I believe, be much more effiecient if executed on the queries
and did the manipulation from the SQL Server throught the use of these
stored procedures. I know what I want to do is possible, but I'm not
%100 comforatble with ODBC and making additions to the Win32::ODBC
module.
Perplexed,
James Leone