FreeTDS Development Group

[Constantin Vasilyev <vasilyev AT ncbi.nlm.nih.gov>]

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
>