On 18/05/2015 16:03, Mike Martin wrote:
Hi
Is it a known issue with running bcp while an active db connection
I have a script that basically
opens a db connection
selects some data
parses/transforms the data
writes to a text file
----------------------
runs bcp to import the data into same database
----------------------
does some updates in SQLServer
The issue is that if I dont disconnect before running bcp, the op just
hangs (with no output).
If I disconnect before bcp and then reconnect everything is fine. Is
this a known issue
Platform Windows 7
SQLServer 2012
DBD::ODBC=1.609
Just sounds like a locking issue to me. How do you connect to your SQL
Server db via Perl and do you disable autocommit or start a transaction?
"Is this a known issue" - not given the information provided unless the
above.
Martin
--
Martin J. Evans
Wetherby, UK