Re: sql parameters truncated to 80 char

Hi - this is a known bug, see this earlier thread I started:
http://lists.ibiblio.org/pipermail/freetds/2010q2/026050.html

On Mon, Jun 28, 2010 at 12:10 AM, Craig A. Berry <[email protected]> wrote:

>
> On Jun 26, 2010, at 10:16 PM, chad phillips wrote:
>
>  running cpan i DBI gives me:
>> Strange distribution name [DBI]
>> Bundle    Bundle::DBI            (TIMB/DBI-1.611.tar.gz)
>> Module  < DBI                    (TIMB/DBI-1.611.tar.gz)
>>
>
> The DBI driver would not be the DBI version but rather, for example,
> DBD::Sybase.
>
>
>  I believe I am running freetds-0.82.  What is the best way to check that
>> for
>> sure?
>>
>
> Set TDSDUMPCONFIG in your environment and look at what it says in the
> resulting log.
>
>
>
>  Any suggestions on how I can fix this?
>>>>
>>>
> Set TDSDUMP in the environment and look at what's actually being sent from
> the client side.
>
> Whittle down your Perl script to a very short reproducer and post it.
>
>
>
>>>> thanks
>>>> chad
>>>>
>>>> DECLARE @p1 INT
>>>> SET @p1 = NULL
>>>> EXEC sp_prepare @p1 OUTPUT, N'@P1 varchar(80)',
>>>>  N'
>>>>    SELECT distinct
>>>>    ses_title,
>>>>             ses_code,
>>>>             ses_start_date,
>>>>             ses_start_time,
>>>>             ses_end_time,
>>>>             lrm_name
>>>>
>>>>
>>>>    FROM     dbo.ev_event
>>>>             JOIN dbo.ev_session ON evt_key = ses_evt_key
>>>>                                    AND ses_delete_flag = 0
>>>>                                    AND evt_code = ''ASA2010''
>>>>             JOIN dbo.ev_session_ext ON ses_key = ses_key_ext
>>>>             LEFT JOIN dbo.client_aafp_m09_cme_session ON ses_m09_key_ext
>>>> = m09_key
>>>>             LEFT JOIN ev_event_session_room ON esr_ses_key = ses_key
>>>>             LEFT JOIN ev_event_location_room ON lrm_key = esr_lrm_key
>>>>             LEFT JOIN ev_event_location ON evl_key = lrm_evl_key
>>>>             left join ev_location (nolock) on loc_key = evl_loc_key
>>>>             LEFT JOIN dbo.ev_session_track_type ON ses_set_key = set_key
>>>>    where
>>>>         ses_title = @p1
>>>>   order by  ses_start_date, ses_start_time
>>>>    ', 1
>>>> select @p1
>>>> EXEC sp_execute 1,    'Cardiac Arrhythmias (including atrial
>>>> fibrillation):
>>>> A Brief Review of Cardiac Arrhythmias'
>>>> _______________________________________________
>>>> FreeTDS mailing list
>>>> [email protected]
>>>>
>>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>>
>>>>  _______________________________________________
>>> FreeTDS mailing list
>>> [email protected]
>>>
>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>
>>>  _______________________________________________
>> FreeTDS mailing list
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>
> ________________________________________
> Craig A. Berry
> mailto:[email protected]
>
> "... getting out of a sonnet is much more
>  difficult than getting in."
>                 Brad Leithauser
>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>