FreeTDS Development Group

[chad phillips <chad AT chadphillips.org>]

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)

I believe I am running freetds-0.82.  What is the best way to check that for
sure?

thanks
chad

On Sat, Jun 26, 2010 at 12:09 PM, Frediano Ziglio <freddy77 AT gmail.com>wrote:

> Which dbi driver are you using? Which FreeTDS version?
>
> Frediano Ziglio
>
> Il giorno 26/giu/2010, alle ore 18.28, chad phillips <
> chad AT chadphillips.org> ha scritto:
>
>  Hi,
>>
>> When I run a select against MSSQL, my sql parameters get limited to 80
>> characters.  I am trying to run a query against a varchar(250) field, buy
>> my
>> parameters get cut off at 80 characters.
>>
>> I am using FreeTDS on a linux box to connect to MSSQL.  We are using perl.
>> The protocol is set to 8.0.  I ran profiler and trapped the sql that is
>> sent.  In the sql you can see where it sets the field to varchar(80)
>> instead
>> of varchar(250).
>>
>> Any suggestions on how I can fix this?
>>
>> 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
>> FreeTDS AT lists.ibiblio.org
>>
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
>
> http://lists.ibiblio.org/mailman/listinfo/freetds
>