Re: Sybase ASE through DBD::ADO: Problem calling proc with param



Thank you for the quick reply!

Steffen Goeldner <sgoeldner@xxxxxxxx> 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


.

Relevant Pages