> I am carrying out a bulk insert from a csv file into a
> SQL Server table using the 'Bulk insert' statement within
> a stored procedure. This operation works okay whenever I
> manually run this sp on the server. However it generates
> the error message shown below whenever I call this sp
> from a VB6 form. The db I am using is a SQL7 db which I
> have restored on a SQL2000 db XP Prof machine, thereby
> making it a SQL2000 db.
>
>
> ------- start error message ----
> 'A different operation is preventing this operation from
> being executed'.
> ---- end error message -----

>-----Original Message-----
>Olu Falowo (ofalowo@hotmail.com) writes:
>> I am carrying out a bulk insert from a csv file into a
>> SQL Server table using the 'Bulk insert' statement
within
>> a stored procedure. This operation works okay whenever
I
>> manually run this sp on the server. However it
generates
>> the error message shown below whenever I call this sp
>> from a VB6 form. The db I am using is a SQL7 db which
I
>> have restored on a SQL2000 db XP Prof machine, thereby
>> making it a SQL2000 db.
>>
>>
>> ------- start error message ----
>> 'A different operation is preventing this operation
from
>> being executed'.
>> ---- end error message -----
>
>I can't find this message in sysmssages, so it is not
likely to be a
>message from SQL Server. The .Error object in ADO
includes a few more
>members beside the .Description field. One of them
is .Source.
>
>It might help if you post the relevant code, including
the VB code.
>
>(And, you can always try SET NOCOUNT ON.)
>
>--
>Erland Sommarskog, SQL Server MVP, sommar@algonet.se
>
>Books Online for SQL Server SP3 at
>http://www.microsoft.com/sql/techinfo/productdoc/2000/boo
ks.asp
>.