Re: Problem with freebcp and fixed text output [NC]

Hi,

Well the issues we are encountering are different and as James said, the
latest patch should address the initial issue of the fixed test output.

The issue one of my teams reported is that if there is a column in the file
that does not get imported into the table, then it fails. The faulty
procedure is _bcp_readfmt_colinfo which fails because TAB_COLNUM is not
present in that case.

Any ideas before I start implementing a fix?

Thanks,

Cedric



|------------------------------                                            
|            "James K. Lowden"                                             
|            <jklowden@freetds                                             
|            .org>                                                         
|            Sent by:                                                      
|            freetds-bounces@l                                             
|            ists.ibiblio.org                                              
|                                                                          
|                                                                          
|            08/05/2009 11:09                                              
|            PM                                                            
|                                                                          
|                                                                          
|            Please respond to                                             
|                 FreeTDS                                                  
|            Development Group                                             
|            <[email protected]                                             
|               iblio.org>                                                 
|                                                                          
|                                                                          
                                                                           
                                                                           
                                                                        To 
                                               FreeTDS Development Group   
                                               <[email protected]> 
                                                                        cc 
                                                                           
                                                                   Subject 
                                               Re: [freetds] Problem with  
                                               freebcp and fixed text      
                                               output                      
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




Modesto Sevilla wrote:
> I am evaluating freebcp as a replacement to bcp (Sybase) while
> connecting to MS Sql Server 2008.  My problem is that when I bcp out a
> table even if I specify a format file, the output does not come out in
> fixed length as it did with bcp.

I think -- I expect! -- that if you install the latest snapshot you'll see
the behavior is corrected.  From ChangeLog:

Fri Jul 10 14:01:28 EDT 2009    JK Lowden <[email protected]>
        * src/dblib/bcp.c pad nullable CHAR written to hostfile.

See the ML discussion around that time.

HTH.

--jkl
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds



*************************************************************************
This message and any attachments (the "message") are confidential, intended 
solely for the addressee(s), and may contain legally privileged information.  
Any unauthorised use or dissemination is prohibited.  E-mails are susceptible 
to alteration.  Neither SOCIETE GENERALE nor any of its subsidiaries or 
affiliates shall be liable for the message if altered, changed or falsified.
*************************************************************************