freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
[freetds] freebcp issue connecting to mssql,
Michel Cunha, 11/14/2006
-
Re: [freetds] freebcp issue connecting to mssql,
Michel Cunha, 11/14/2006
-
Re: [freetds] freebcp issue connecting to mssql,
Konrad J Hambrick, 11/14/2006
- Re: [freetds] freebcp issue connecting to mssql, Michel Cunha, 11/14/2006
- Re: [freetds] freebcp issue connecting to mssql, Michel Cunha, 11/15/2006
-
Re: [freetds] freebcp issue connecting to mssql,
Konrad J Hambrick, 11/14/2006
- Re: [freetds] freebcp issue connecting to mssql, James K. Lowden, 11/14/2006
-
Re: [freetds] freebcp issue connecting to mssql,
Michel Cunha, 11/14/2006
Archive powered by MHonArc 2.6.24.