Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS 0.64 problem with freebcp on Linux x86_64 platform

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Constantin Vasilyev <vasilyev AT ncbi.nlm.nih.gov>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS 0.64 problem with freebcp on Linux x86_64 platform
  • Date: Mon, 31 Jul 2006 15:36:06 -0400 (EDT)

Thanks much! That was really helpful!

Constantin Vasilyev
NCBI Contractor, DBA

On Mon, 31 Jul 2006, Lowden, James K wrote:

> > From: Constantin Vasilyev
> > Sent: Monday, July 31, 2006 1:07 PM
> >
> > I'm trying to use FreeTDS 0.64 built on Linux 64 bit platform to
> > communicate with MS SQL 2000 server:
> >
> > dbmaint01 ~> uname -a Linux dbmaint01 2.6.12.3-EM64T #1 SMP Mon
> > Jul 18 11:03:02 EDT 2005 x86_64 unknown
> >
> > The package compiled with no problems, but when I tried to use
> > freebcp it gave strange error:
> >
> > dbmaint01 ~/clients-mssql/freetds-0.64/bin> ./freebcp sysobjects
> > out /tmp/foo.bcp -S MSSQL0 -c -U ... -P ... Msg -100, Level 11
> > unrecognized msgn
>
> Well, it could be a more helpful message, but I think I know the
> problem:
>
>
> src/dblib/bcp.c::bcp_init():
>
> /*
> * Validate other parameters
> */
> #define SYBETDSVER -100
> if (dbproc->tds_socket->major_version < 5) {
> dbperror(dbproc, SYBETDSVER, 0);
> return (FAIL);
> }
>
> BCP works only with TDS versions 5.0 and up. You appear to be using a
> TDS 4.2 connection. In older versions, you'd get weird behavior with
> 4.2; now you get a cryptic message.
>
> HTH.
>
> --jkl
>
> -----------------------------------------
> The information contained in this transmission may be privileged and
> confidential and is intended only for the use of the person(s) named
> above. If you are not the intended recipient, or an employee or agent
> responsible
> for delivering this message to the intended recipient, any review,
> dissemination,
> distribution or duplication of this communication is strictly prohibited.
> If you are
> not the intended recipient, please contact the sender immediately by reply
> e-mail
> and destroy all copies of the original message. Please note that we do not
> accept
> account orders and/or instructions by e-mail, and therefore will not be
> responsible
> for carrying out such orders and/or instructions. If you, as the intended
> recipient
> of this message, the purpose of which is to inform and update our clients,
> prospects
> and consultants of developments relating to our services and products,
> would not
> like to receive further e-mail correspondence from the sender, please
> "reply" to the
> sender indicating your wishes. In the U.S.: 1345 Avenue of the Americas,
> New York,
> NY 10105.
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>





Archive powered by MHonArc 2.6.24.

Top of Page