FreeTDS Development Group

["Satya Madhav" <smadhav.vangara AT inucom.com>]

Hi 
I would like to use BCP utility for SQL Server  to load data from a UNIX
box...
I know there is freebcp and freetds freeware to do that  But will they
support the parallelism provided by the bcp given by the Microsoft SQL
Server?
 Or coan you suggent any tools or utilities which can do that???

TIA
Satyamadhav


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
freetds-request AT lists.ibiblio.org
Sent: Thursday, July 29, 2004 9:38 PM
To: freetds AT lists.ibiblio.org
Subject: FreeTDS Digest, Vol 18, Issue 38


Send FreeTDS mailing list submissions to
        freetds AT lists.ibiblio.org

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.ibiblio.org/mailman/listinfo/freetds
or, via email, send a message with subject or body 'help' to
        freetds-request AT lists.ibiblio.org

You can reach the person managing the list at
        freetds-owner AT lists.ibiblio.org

When replying, please edit your Subject line so it is more specific than
"Re: Contents of FreeTDS digest..."


Today's Topics:

   1. Re: FreeTDS Digest, Vol 18, Issue 37 (jun_chen AT bankone.com)
   2. RE: Re: FreeTDS Digest, Vol 18, Issue 37 (ZIGLIO, Frediano, VF-IT)
   3. freetds thread safe ? (BALTUS Jean)
   4. Re: Problem with OTL & bulk insert (Piet De Jong)
   5. Re: Problem with OTL & bulk insert (Piet De Jong)
   6. freetds 0.6.2.4 (BALTUS Jean)
   7. RE: Problem with OTL & bulk insert (Lowden, James K)
   8. RE: freetds 0.6.2.4 (Lowden, James K)


----------------------------------------------------------------------

Message: 1
Date: Wed, 28 Jul 2004 13:30:46 -0400
From: jun_chen AT bankone.com
Subject: [freetds] Re: FreeTDS Digest, Vol 18, Issue 37
To: freetds AT lists.ibiblio.org
Message-ID:
        
<OFEAFAD559.2E726A36-ON85256EDF.005F6448-85256EDF.005FA95A AT dc.bankone.ne
t>
        
Content-Type: text/plain; charset="us-ascii"

freddy77,

Here is the SQL log file:



Thanks.

Jun 


Jun Chen

freetds-request AT lists.ibiblio.org
Sent by: freetds-bounces AT lists.ibiblio.org
07/28/2004 12:06 PM
Please respond to freetds

 
        To:     freetds AT lists.ibiblio.org
        cc: 
        Subject:        FreeTDS Digest, Vol 18, Issue 37



   1. RE: Re: FreeTDS Digest, Vol 18, Issue 31 (ZIGLIO, Frediano, VF-IT)
   2. RE: Problem with OTL & bulk insert (ZIGLIO, Frediano, VF-IT)


----------------------------------------------------------------------

Message: 1
Date: Wed, 28 Jul 2004 17:36:18 +0200
From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
Subject: RE: [freetds] Re: FreeTDS Digest, Vol 18, Issue 31
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Message-ID:
<F7F148C986A2A84F930FEB8C3B169EA08531F7 AT OPDMEXO01.omnitel.it>
Content-Type: text/plain;                charset="US-ASCII"

> 
> freddy77,
> 
> Did you get the attached SQL log and have a chance to take a
> look at the 
> issue?
> 
> Jun
> 

No...

freddy77





This transmission may contain information that is privileged,
confidential and/or exempt from disclosure under applicable law. If you
are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED. If you
received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic
or hard copy format. Thank you.


------------------------------

Message: 2
Date: Thu, 29 Jul 2004 08:40:44 +0200
From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
Subject: RE: [freetds] Re: FreeTDS Digest, Vol 18, Issue 37
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Message-ID:
        <F7F148C986A2A84F930FEB8C3B169EA08531F9 AT OPDMEXO01.omnitel.it>
Content-Type: text/plain;       charset="US-ASCII"

> 
> freddy77,
> 
> Here is the SQL log file:
> 
> 
> 
> Thanks.
> 
> Jun 
> 

Still no attach, read James mail on topic or send privately to me

freddy77


------------------------------

Message: 3
Date: Thu, 29 Jul 2004 15:23:26 +0200
From: "BALTUS Jean" <jean.baltus AT africamuseum.be>
Subject: [freetds] freetds thread safe ?
To: <freetds AT lists.ibiblio.org>
Message-ID:
        
<6CE902AA4C1E544E8806E97FF06B7D330FE79A AT intramail.museum.africamuseum.be
>
        
Keywords: disclaimer
Content-Type: text/plain;       charset="us-ascii"

Hi all,

 

We are using freetds to connect to a MSQL database from a RedHat 8
machine.

We have also installed unixODBC with thread safetiness.

 

If we create several processes (through isql or tsql): freetds behaves
correctly.

 

However when using an external application that uses threads (either the
DataManager of unixODBC or Zope through egenix mxODBCZopeDA ), the
driver crashes and leads to a crash of the external application as well.

 

Could you please provide me information regarding :

 

-          To what extend is freetds thread safe ? What are the
requirements (particular c compiler? MS SQL version ? other libraries
dependencies ?)

-          How can we test thread safety of free tds? do you have a unit
test for this ?

-          How can we get more information of what's going on when the
driver crashes (trace, debugging possible ?)

 

Thanks for your input, we are really clueless here,

 

-- Jean

 

###########################################

This message has been scanned by ICT - Africa Museum


------------------------------

Message: 4
Date: Thu, 29 Jul 2004 15:35:54 +0200
From: "Piet De Jong" <piet AT ahead-tech.net>
Subject: Re: [freetds] Problem with OTL & bulk insert
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Message-ID: <01f901c47570$f96f89c0$5000a8c0@piet>
Content-Type: text/plain;       charset="iso-8859-1"

Freddy,

I saw some discussion regarding bulk copy on the list recently, would
that
not be a possibility to use ?
( I am under the impression that the bulk copy you talk about is the
same as
the bulkcopy program from mssql. )

Many thanks
Piet




------------------------------

Message: 5
Date: Thu, 29 Jul 2004 16:09:42 +0200
From: "Piet De Jong" <piet AT ahead-tech.net>
Subject: Re: [freetds] Problem with OTL & bulk insert
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Message-ID: <022001c47575$b35370f0$5000a8c0@piet>
Content-Type: text/plain;       charset="iso-8859-1"

I saw it in the docs directory, should have checked first before posting
the
SQ.
Will give it a try.
PIet



------------------------------

Message: 6
Date: Thu, 29 Jul 2004 16:32:34 +0200
From: "BALTUS Jean" <jean.baltus AT africamuseum.be>
Subject: [freetds] freetds 0.6.2.4
To: <freetds AT lists.ibiblio.org>
Message-ID:
        
<6CE902AA4C1E544E8806E97FF06B7D330FD630 AT intramail.museum.africamuseum.be
>
        
Keywords: disclaimer
Content-Type: text/plain;       charset="us-ascii"

I installed the latest freetds with -enable-threadsafe and without the
flag.

 

At installation, it says thread safety OK.

 

When installed, if you run ./tsql -C, it says:

 

Thrad safety : No !!! ????????

 

Can anybody give me a clue ?

 

(Redhat 8 used)

 

-- Jean

 

###########################################

This message has been scanned by ICT - Africa Museum


------------------------------

Message: 7
Date: Thu, 29 Jul 2004 10:10:09 -0400
From: "Lowden, James K" <LowdenJK AT bernstein.com>
Subject: RE: [freetds] Problem with OTL & bulk insert
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Message-ID:
        
<3778FAB3D61A7A40833F1CB3B8C173AA02A2F62A AT AC2KAMA0107.ac.lp.acml.com>
Content-Type: text/plain;       charset="us-ascii"

> From: Piet De Jong
> Sent: Thursday, July 29, 2004 9:36 AM
> 
> I saw some discussion regarding bulk copy on the list 
> recently, would that not be a possibility to use ? 

Bulk copy operation is supported by db-lib and ct-lib.  It has not yet
been implemented in the ODBC driver.  (It's also not in the ODBC spec;
it's a Microsoft extension.)

> ( I am 
> under the impression that the bulk copy you talk about is the 
> same as the bulkcopy program from mssql. )

You mean BCP.EXE?  Yes, that program uses the same parts of the TDS
protocol that FreeTDS implements with db-lib and ct-lit.  

--jkl

-----------------------------------------
The information contained in this transmission may contain privileged
and confidential information 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.




------------------------------

Message: 8
Date: Thu, 29 Jul 2004 11:02:58 -0400
From: "Lowden, James K" <LowdenJK AT bernstein.com>
Subject: RE: [freetds] freetds 0.6.2.4
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Message-ID:
        
<3778FAB3D61A7A40833F1CB3B8C173AA02A2F62C AT AC2KAMA0107.ac.lp.acml.com>
Content-Type: text/plain; charset="us-ascii"

> From: BALTUS Jean
> Sent: Thursday, July 29, 2004 10:33 AM
> 
> I installed the latest freetds with -enable-threadsafe and 
> without the flag.
... 
> When installed, if you run ./tsql -C, it says:
> 
> Thrad safety : No !!! ????????

Please apply the attached patch.  

The function called by "tsql -C" relied on a compile-time #define that
we apparently don't use anymore.  It's misreporting the status of
--enable-threadsafe.  

[Memo to file: remove -D_THREAD_SAFE from configure.in:426.]

--jkl

-----------------------------------------
The information contained in this transmission may contain privileged
and confidential information 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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: config.diff
Type: application/octet-stream
Size: 475 bytes
Desc: config.diff
Url :
https://lists.ibiblio.org/sympa/arc/freetds/attachments/20040729/138720b5
/config-0001.obj

------------------------------

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


End of FreeTDS Digest, Vol 18, Issue 38
***************************************