Home All Groups Group Topic Archive Search About

BCP Utility -- not a valid Win32 application

Author
11 May 2006 4:43 PM
JT
I downloaded SQL Server Express yesterday for the first time.  I used
the BCP utility a couple of times without incident but then it stopped
working.  I received a message reading "BCP is not a valid Win32
application".  I uninstalled and reinstalled SQL Server Express but it
did not resolve the issue.

Does anyone have any idea how to resolve this?  If not, is there a
reasonable alternative I could use for importing/exporting data?  Thank
you.

Author
11 May 2006 10:10 PM
Erland Sommarskog
JT (john.thr***@gmail.com) writes:
> I downloaded SQL Server Express yesterday for the first time.  I used
> the BCP utility a couple of times without incident but then it stopped
> working.  I received a message reading "BCP is not a valid Win32
> application".  I uninstalled and reinstalled SQL Server Express but it
> did not resolve the issue.
>
> Does anyone have any idea how to resolve this?  If not, is there a
> reasonable alternative I could use for importing/exporting data?  Thank
> you.

That sounds strange. Like the exe file got damaged. Has your machine
caught a virus?

Check your PATH to see if there is another BCP ahead of the SQL Server
BCP in the path.


--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Author
12 May 2006 2:09 PM
JT
Thanks for the response.  Yes, the file appears to be corrupt as it's
size is indicated as 0k.  I've done some research and it appears some
others have had similar issues but I've not found any solutions.  As
stated previously, I tried reinstalling to no avail.  In the meantime,
I've been using bulk insert queries which have been serving my purposes.
Author
12 May 2006 4:30 PM
Erland Sommarskog
JT (john.thr***@gmail.com) writes:
> Thanks for the response.  Yes, the file appears to be corrupt as it's
> size is indicated as 0k.  I've done some research and it appears some
> others have had similar issues but I've not found any solutions.  As
> stated previously, I tried reinstalling to no avail.  In the meantime,
> I've been using bulk insert queries which have been serving my purposes.

Delete the 0K file. Open Add/Remove programs and go to SQL Express. Try
running a repair.


--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Author
15 May 2006 2:09 PM
JT
That did the trick.  Thanks for the hand, Erland.

AddThis Social Bookmark Button