Skip to Content.
Sympa Menu

freetds - Re: [freetds] freebcp issue connecting to mssql

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michel Cunha <mcunha AT n-able.com>
  • To: konrad AT jax01.payplus.com, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] freebcp issue connecting to mssql
  • Date: Wed, 15 Nov 2006 09:56:26 -0500

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





Archive powered by MHonArc 2.6.24.

Top of Page