DBD::ODBC, FreeTDS and Stored Procedure

InfiniteLoop has asked for the wisdom of the Perl Monks concerning the following question:

Greetings Monks,

I have installed DBD::ODBC and have setup FreeTDS driver, via unixodbc, to connect to a MS SQL server. Here is my simple test code to execute a stored procedure:

use DBI;
my $DSN = 'driver=FreeTDS;Server=mssql_server; database=test;uid=user;
+pwd=password;';
my $dbh = DBI->connect("dbi:ODBC:$DSN") or die "$DBI::errstr\n";

my $sth = $dbh->prepare('EXEC sp_who');
$sth->execute();
[download]

While executing this code, I get the error:
DBD::ODBC::st execute failed: (DBD: st_execute/SQLExecute err=-1)
I have searched the monastory and found a few questions, such as MS SQL Stored Procedure Syntax, however there didn't seem to be any conclusive answers.

How do I execute stored procedure against a MS SQl server, using DBD::ODBC ? Although Im not able to execute a stored procedure, other SQL queries work. Thanks.

Comment on DBD::ODBC, FreeTDS and Stored Procedure Download Code

Replies are listed 'Best First'.
Re: DBD::ODBC, FreeTDS and Stored Procedure by imp (Priest) on Sep 28, 2006 at 20:36 UTC
The syntax for the stored procedure call is fine, so your problem is elsewhere. I haven't looked at unixodbc for about 5 years, but I have used iodbc with freetds to talk to a mssql in the past year with no problems. If that is an option for you, the installation instructions I provided in this node might be useful.	[reply]
Re: DBD::ODBC, FreeTDS and Stored Procedure by mje (Curate) on Sep 29, 2006 at 10:31 UTC
If you ran make test when you built DBD::ODBC and were connecting to MS SQL Server, the test 20SqlServer should have been run and that includes calls to procedures (look in t/20SqlServer in the DBD::ODBC distribution). There should have been more to the error message than you have provided. The proper ODBC syntax is `{ call sp_who() }`	[reply] [d/l]


more useful options
	PerlMonks