Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeBCP to SQL Azure complains table is missing?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeBCP to SQL Azure complains table is missing?
  • Date: Tue, 20 Nov 2012 09:14:48 +0000

2012/11/19 Cade Roux <cade AT roux.org>:
> Of course SQL Azure only lets you connect to one database, so I think
> there is some sort of confusion here.
>
> Has anyone used FreeBCP to connect to SQL Azure?
>
> $ freebcp DWSTAGE.BCPTEST in bcptest.txt -f cdr.fmt -S
> serverfromfreetds -U user@azureserver -P password
> Msg 208, Level 16, State 1
> Server 'azureserver', Line 1
> Invalid object name 'DWSTAGE.BCPTEST'.
> Msg 208, Level 16
> General SQL Server error: Check messages from the SQL Server
>
> Msg 20064, Level 2
> Attempt to use Bulk Copy with a non-existent Server table
>
> $ freebcp DATABASENAME.DWSTAGE.BCPTEST in bcptest.txt -f cdr.fmt -S
> serverfromfreetds -U user@azureserver -P password
> Msg 40515, Level 15, State 1
> Server 'azureserver', Line 16
> Reference to database and/or server name in
> 'DATABASENAME.DWSTAGE.BCPTEST' is not supported in this version of SQL
> Server.
> Msg 40515, Level 15
> General SQL Server error: Check messages from the SQL Server
>
> Msg 20064, Level 2
> Attempt to use Bulk Copy with a non-existent Server table
>
>
> I've also tried adding the database to the command line with the -D
> option. The default database for that connection is set up as this one
> and only Azure database in the freetds.conf.
>
> The connection to SQL Azure seems fine otherwise - I just can't get
> FreeBCP to work:
>
> $ isql serverfromfreetds user@azuredatabasename password
> +---------------------------------------+
> | Connected! |
> | |
> | sql-statement |
> | help [tablename] |
> | quit |
> | |
> +---------------------------------------+
> SQL> SELECT COUNT(*) FROM DWSTAGE.BCPTEST;
> +------------+
> | |
> +------------+
> | 0 |
> +------------+
> SQLRowCount returns 1
> 1 rows fetched
> SQL> SELECT COUNT(*) FROM DWSTAGE.BCPTESTX;
> [ISQL]ERROR: Could not SQLExecute
> SQL>
>
> This seems like some database/schema confusion, but I can't find a
> combination of settings which works.
>
>
>
> Cade Roux
> cade AT roux.org
> 504-717-4887

Hi,
I thinkg freebcp just load the data into the table, you have to
create the table before running freebcp

Frediano




Archive powered by MHonArc 2.6.24.

Top of Page