Thank you for the quick reply!
Steffen Goeldner <[EMAIL PROTECTED]> schrieb am 18.07.05 14:37:00: > > Philip Zembrod wrote: > [...] > > What I would finally like to do is call a stored proc with an output > > parameter > > through OLE DB. But as yet I can't even call a procedure with an input > > parameter. > > Currently, DBD::ADO doesn't support bind_param_inout(). Yes, I thought so. Can I offer some support in changing that? > > I basically get the following error message: > > > >>OLE exception from "ASE OLE DB Provider": > >> > >>No value given for one or more required parameters [...] > > My environment is: > > WinXP SP1 (german) > > ActivePerl 5.8.2 build 808 > > DBI 1.49 > > DBD::ADO 2.94 > > DBD::Sybase 1.04.12 > > Sybase ASE OLE DB Provider 2.70.0.24 > > Sybase ASE 12.5.3 [...] > > I have no Sybase available, only it's derivative: > > set DBI_DSN=dbi:ADO:Provider=SQLOLEDB;Trusted_Connection=Yes > > Running > > my $sth = $dbh->prepare('sp_help @objname = ?'); > $sth->bind_param( 1,'sysobjects'); > $sth->execute; > $sth->dump_results; > > shows > > 'sysobjects', 'dbo', 'system table', '2002-12-17 14:36:10' > 1 rows So I have probably run into a problem with the Sybase ASE OLE DB Provider. I'll to dig into that some more. Regards Philip