FreeTDS Development Group

[Michel Cunha <mcunha AT n-able.com>]

I finally make it working by changing freetds.conf file.
Michel

On Tuesday 14 November 2006 14:44, Konrad J Hambrick wrote:
> Michel --
>
> 1. How did you create the bcp file ?
>
>     On UNIX / Linux then might the line
>     ending be "\n" instead of "\r\n" ?
>
> 2. I have also had better luck using
>     "SYBCHAR" than "SQLCHAR" with freebcp.
>
> 3. I don't use the Format Version 8.0.
>     I use 7.0 instead:
>
>        1 SYBCHAR 0  10  "\n"  1  col1
>
> HTH.
>
> -- kjh
>
> Michel Cunha wrote:
> > Note that In step 4 I wanted to say:
> >  run the command (Note that my DB is called mcunha, the table is called
> > allo) Michel
> >
> > On Tuesday 14 November 2006 13:44, Michel Cunha wrote:
> >>Hi can someone help me with freebcp issue
> >>
> >>Did freebcp work in the past with MSSQL server ?
> >>
> >>Here the steps that I did:
> >>
> >>1.create the bcp file
> >>a
> >>b
> >>c
> >>
> >>2.create the destination table
> >>create table allo (col1 varchar(10))
> >>
> >>3.create the format file
> >>8.0
> >>1
> >>1 SQLCHAR 0 1 "\r\n" 1 col1 Latin1_General_CI_AS
> >>
> >>4. run the command (Note that my DB is called mcunha, the table is called
> >>mcunha)
> >>freebcp mcunha..allo
> >>in /var/lib/datafilemanager/dataping_aggregated/20061104/000233/datafile3
> >>-S19x.1xx.xx.xxx:1433 -U xx -P xx -f/tmp/format
> >>
> >>(Note that I change the IP in this email for security reasons :)
> >>
> >>Then I get this error msg:
> >>Msg -100, Level 11
> >>unrecognized msgno
> >>
> >>I look at google, did not find anything that was usefull
> >>
> >>Can anyone help me with this issue ??
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds