hi,
do you install the dsn as system-dsn in windows? ado runs only under odbc
and you need the system-dsn.
hope i can help you.
good luck
erik
-----Ursprüngliche Nachricht-----
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Im Auftrag von
Perl Developer
Gesendet: Freitag, 10. November 2000 20:51
An: [EMAIL PROTECTED]
Betreff: Perl-ADO-SQL-Stored Procedures
Hi All,
Does anyone have experience with using Perl, DBI, ADO to execute SQL Stored
procedure that can update input parameters for use as output.
Here is my example: sp_test_1 is stored proc that chancges value of $y. Perl
script:
use DBI;
use DBD::ADO;
$dbh = DBI->connect('dbi:ADO:DSN', 'name', 'password')
|| die $DBI::errstr;
$y = 5;
$sth = $dbh->prepare("execute sp_test_1 ?");
$rc = $sth->bind_param_inout(1, \$y, 1) || die $dbh->errstr;
$sth->execute;
$dbh->disconnect;
print "y = $y\n";
It must be 10 after call.
sp_test_1 works from Query Analyzer, but when I run this script I get a
stange error:
"Can't locate DBI object method "bind_param_inout" via package
"DBD::ADO::st"."
As far as I know there is no st package. Can you explain why it doesn't
work?
Thank you.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users
