Skip to Content.
Sympa Menu

freetds - [freetds] what's wrong with this freebcp statement?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "blackwater dev" <blackwaterdev AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] what's wrong with this freebcp statement?
  • Date: Wed, 15 Mar 2006 14:12:44 -0500

I need to connect to a remove SQL server and grab all the data from a view.
here is what I am using (of course I have changed names and ip addresses):

freebcp databasename.viewname out data.sql -U username -P mypass -S
999.99.999.99:1433 -n

I know the credentials are good because I can connect via php but when run,
I get this:

Msg 208, Level 16, State 1
Server 'MIRROR', Line 1
Invalid object name 'databasename.viewname'.
Msg 20018, Level 5
General SQL Server error: Check messages from the SQL Server.

Error in dbnumcols

What am I doing wrong?

Thanks!




Archive powered by MHonArc 2.6.24.

Top of Page