Re: Issue with DBD::ODBC (SQLServer) and bcp

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