FreeTDS Development Group

["Chris McDaniel" <Chris.McDaniel AT telus.com>]

Only too happy to help - thanks to all developers - for giving us freetds

here's my freetds.log excerpt (500 lines) and the DBI trace as well, just in
case...
 
Thanks,

Chris McDaniel

-----Original Message-----
From: Lowden, James K [mailto:LowdenJK AT bernstein.com]
Sent: January 6, 2003 10:55 AM
To: 'freetds AT lists.ibiblio.org'
Subject: RE: [freetds] DBD::ODBC (0.45), MS SQL, unixODBC, FreeTDS
(CVS), bind_param_ino ut


> From: Chris McDaniel [mailto:Chris.McDaniel AT telus.com]
> Sent: January 6, 2003 10:34 AM
> 
> Does anyone know why I'm not getting any data out of the 
> @params marked
> OUTPUT in the proc? 

Chris, 

You're using brand new functionality.  Frediano added support for output
parameters in December, and I'm not sure anyone's tried to use it yet with
perl.  

Post the last 500 lines of your TDSDUMP log.  It should show what's going
on.  Maybe perl requires an ODBC feature we don't support (yet), or it's
calling the driver in a way we didn't anticipate.  

Thanks for your help debugging this.  :)

--jkl

> $sth = $dbh->prepare('execute p_ccs_MakeBooking 
> @ClientAccount="xxxxxx",
> @PaymentNumber="xxxxxx", @ConferenceName="Scripts: 06:47 Booked",
> @ConferenceComments="Created by Chris McDaniel", @ConferenceType=1,
> @LanguageType=1, @PriorityType=2, @StartDateTime="2003-02-01 
> 12:30:00",
> @Duration=10, @Conferees=3, @SubConferees=0, @TollFreeInd=1,
> @RecordingInd=1, @EnterToneInd=1, @LeavingToneInd=1, @QandAInd=1,
> @PollingInd=1, @RollCallInd=1, @BroadcastInd=1, @DemandInd=0,
> @ModeratorInd=1, @AutoPINInd=1, @DDI=?, @CPIN=?, @MPIN=?,
> @RecordingPIN="555", @Information=?, @ReservationRef=?, 
> @ConferenceRef=?,
> @ActualDuration=?, @AvailableInd=?');
> 
> $sth->bind_param_inout(1, \$DDI, 32, DBI::SQL_VARCHAR);
> $sth->bind_param_inout(2, \$CPIN, 12, DBI::SQL_VARCHAR);
> $sth->bind_param_inout(3, \$MPIN, 12, DBI::SQL_VARCHAR);
> $sth->bind_param_inout(4, \$Info, 255, DBI::SQL_VARCHAR);
> $sth->bind_param_inout(5, \$ResRef, 10, DBI::SQL_INTEGER);
> $sth->bind_param_inout(6, \$ConfRef, 10, DBI::SQL_INTEGER);
> $sth->bind_param_inout(7, \$ActDuration, 10, DBI::SQL_INTEGER);
> $sth->bind_param_inout(8, \$AvailInd, 1, DBI::SQL_BIT);
> $sth->execute();


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

Attachment: dbi.trace
Description: Binary data

Attachment: freetds.log
Description: Binary data