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: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] freebcp issue connecting to mssql
  • Date: Tue, 14 Nov 2006 13:53:42 -0500

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 ??

--
Regards,

Michel Cunha
Software Developer
N-able Technologies
450 March Road, 4th Floor
Ottawa, Ontario
Canada
K2K 3K2

www.n-able.com
mcunha AT n-able.com
Tel: (613) 592-6676 x341
Toll Free: 877-655-4689 x341
Fax: (613) 592-2242




Archive powered by MHonArc 2.6.24.

Top of Page