Skip to Content.
Sympa Menu

freetds - Re: [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: Re: [freetds] what's wrong with this freebcp statement?
  • Date: Wed, 15 Mar 2006 14:19:01 -0500

Ok, I added the dbo owner and now get segmentation fault.
On 3/15/06, blackwater dev <blackwaterdev AT gmail.com> wrote:
>
> 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