Re: bcp problems

Hi,

Just to let you know that I made some progress with this, thanks Bill! I will let you know if I need further advice.

Cheers,

Panos.

--- On Thu, 20/1/11, Panos Stavroulis <[email protected]> wrote:

> From: Panos Stavroulis <[email protected]>
> Subject: [freetds] bcp problems
> To: [email protected]
> Date: Thursday, 20 January, 2011, 11:16
> Hi,
> 
> I have a bcp related problem. I am trying to insert the
> following table via bcp:
> insert bulk #Tran_Driver (msg_id int, local_id int,
> parent_id int, splitno int, drivertype char(4), drivercode
> char(4), status char(4))
> 
> In principal do you have to adjust the size of each column
> to cater for strings or chars? I don't think need to do
> anything for numerics.
> 
> It fails on function :_bcp_get_col_data(39f78, 90538), see
> below and also attachment with more info. It's compaining
> about the terminator and always fails on the last row of the
> temp table. I've changed the order so an insertion to a
> different tables again failed with the last column. 
>  
> 
> Pls see attached the output. does anyone know what's wrong?
> FYI bcp works in other places of the code.
> 
>  
> bcp.c:3187:_bcp_send_bcp_record(39f78, 1)
> bcp.c:3401:_bcp_get_col_data(39f78, 69040)
> dblib.c:2141:dbconvert(39f78, SYBINT4, 5fcc0, 4, SYBINT4,
> 4f5b8, 4)
> dblib.c:2174:dbconvert() srctype == desttype
> bcp.c:3217:parsed column 1, length 4 (not null)
> bcp.c:3283:new_record_size = 0 datalen = 4 
> bcp.c:3307:old_record_size = 35 new size = 4 
> bcp.c:3401:_bcp_get_col_data(39f78, 694b8)
> dblib.c:2141:dbconvert(39f78, SYBINT4, 5fcc4, 4, SYBINT4,
> 4f538, 4)
> dblib.c:2174:dbconvert() srctype == desttype
> bcp.c:3217:parsed column 2, length 4 (not null)
> bcp.c:3283:new_record_size = 4 datalen = 4 
> bcp.c:3307:old_record_size = 35 new size = 8 
> bcp.c:3401:_bcp_get_col_data(39f78, 69da8)
> dblib.c:2141:dbconvert(39f78, SYBINT4, 5fcc8, 4, SYBINT4,
> 4f468, 4)
> dblib.c:2174:dbconvert() srctype == desttype
> bcp.c:3217:parsed column 3, length 4 (not null)
> bcp.c:3283:new_record_size = 8 datalen = 4 
> bcp.c:3307:old_record_size = 35 new size = 12 
> bcp.c:3401:_bcp_get_col_data(39f78, 6a220)
> dblib.c:2141:dbconvert(39f78, SYBINT4, 5fccc, 4, SYBINT4,
> 4f3f8, 4)
> dblib.c:2174:dbconvert() srctype == desttype
> bcp.c:3217:parsed column 4, length 4 (not null)
> bcp.c:3275:varint_1 = 4
> bcp.c:3283:new_record_size = 13 datalen = 4 
> bcp.c:3307:old_record_size = 35 new size = 17 
> bcp.c:3401:_bcp_get_col_data(39f78, 6a698)
> dblib.c:2141:dbconvert(39f78, SYBCHAR, 5fcd0, -1, SYBCHAR,
> 4f658, 4)
> dblib.c:2174:dbconvert() srctype == desttype
> bcp.c:3217:parsed column 5, length 4 (not null)
> bcp.c:3283:new_record_size = 19 datalen = 4 
> bcp.c:3307:old_record_size = 35 new size = 23 
> bcp.c:3401:_bcp_get_col_data(39f78, 6ab10)
> dblib.c:2141:dbconvert(39f78, SYBCHAR, 5fcd5, -1, SYBCHAR,
> 6b9a0, 4)
> dblib.c:2174:dbconvert() srctype == desttype
> bcp.c:3217:parsed column 6, length 3 (not null)
> bcp.c:3283:new_record_size = 25 datalen = 3 
> bcp.c:3307:old_record_size = 35 new size = 28 
> bcp.c:3401:_bcp_get_col_data(39f78, 90538)
> 00000059 2011/01/19 04:03:59.443 C   
>    -6 SERI SERVER       
>               Found
> system error (6)
> 
> 
>       
> -----Inline Attachment Follows-----
> 
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>