.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Unable to open BCP host data-file

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
I am having trouble with BCP. I get the same error with xp_cmdshell as I do with entering bcp as a DOS command. I have checked and rechecked the file names and permissions and even restart the PC.

Does BCP even work when SQL Server 2005 Express on a PC?

declare @sql varchar(8000)
select @sql = 'bcp SYMITAR..ACCOUNT in C:\test\EXTRACT.ACCOUNT -T -f C:\test\ACCOUNT.FMT -S'+@@servername
exec SYMITAR..xp_cmdshell @sql

Volume in drive C has no label.
Volume Serial Number is 08E5-2414

Directory of C:\test

02/13/2007 08:44 AM <DIR> .
02/13/2007 08:44 AM <DIR> ..
08/31/2006 09:11 AM 27,503,161 EXTRACT.ACCOUNT
08/31/2006 09:12 AM 6,879 FMT.ACCOUNT
02/07/2007 08:46 AM 220 ACCTTYPE.FMT
02/13/2007 08:44 AM 0 filelisting.txt
02/07/2007 08:33 AM 220 ACCTTYPE.xml
5 File(s) 27,510,480 bytes
2 Dir(s) 54,344,847,360 bytes free

Could the fact that it's actually pulling BCP from c:\Program Files\Microsoft SQL Server\80\Tools\binn\ be a problem? I know this because it doesn't recognize the -x extensionof the bcp command.

%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Common Files\GTK\2.0\bin;C:\Program Files\Microsoft SQL Ser

View Complete Post

More Related Resource Links

SPS 2003 : Unable to open file more than 1Mb

Hi, I work in the creation of a portal in SPS 2003. We found that some documents whose size was greater than 1 Mb can no longer be opened. Word returns a runtime error "1177". When we restart the farm ,problem is resolved but reappeared after several hours .We have tried to restart the database to see if it could solve the problem, the problem is not corrected. Then we restarted the front-end web services SharePoint, this does not work. Then we did an IIS reset,the problem is not corrected. This problem affects all types of documents (pdf, doc, ppt, xls ...). Thanks for your help. Best Regards. Mawi. + DEVELOPER

Unable to open physical file - Operating system error 5: 5(error not found) Microsoft SQL Server: Er

I am trying to attach a database to SQL 2005. This database has not previously been attached. I have only just installed SQL.   I get the following message: Unable to open physical file "C:\ArrowSQL\Arr@Data\Arrow_data.mdf" Operating system error 5: "5(error not found)" (Microsoft SQL Server: Error 5120)".   I have loaded SQL and the database fiel and directory with the same user acccount which is a local adminstrator ont hsi machine. I have checked that I have read/write access to the file.   The machine runs Windows Vista Business. SQL has SP 2 loaded.   What causes this?

Unable to export data to an excel file in grid format!!!

I'm exporting data to an excel sheet from the ojects list. The data is exporting to excel sheet well, but I'm unable to see the grid format for the data. The data is looking with out the rows and columns lines. I think I'm missing to set some property or somethnig ehwn exporting.   Any help would be really appriciated.

Unable to correct data formats on host


I created web pages that used an SQL database on my home computer.  That DB allowed me to use data types such as 'date' and 'time'.  But when I transferred my website to a host server, I discovered that its DB does not accept these types.  They only use 'datetime' and 'timestamp'.  I changed the tables in the DB on my computer to conform to the same format as on the host computer.  I also changed the properties to the new data types with the O/R Developer and re-published the website files to the host server.  But I keep getting the same error message that states the server does not support 'date' data types whenever I execute a web page that uses that table column.  The C# code states "officetable.StartDate = DateTime.Today;"  What should I do?  Please help.


Unable to load data from txt file with text delimiter specified, if the data has the same character


Have come across a strange scenario and seeking your ideas/thoughts.

I'm using a ssis package to load a txt file. The txt file is text delimited by double quote (") and column delimited by tilde (~). It works fine in most scenarios and strips the enclosing "" from the columns -no problems there. However, in a specific scenario where the last column has double quote in the data as well being the text delimiter, the package throws the following exception indicating that it's missing a column delimiter

 The column delimiter for column "COL_NAME" was not found

This behaviour was not observed when double quotes were present as data in any other column in the file. Was able to workaround by disabled text delimiter only for the last column, but that isn't a perm solution. Also observed that if the " was replaced by escape sequence /" the file loaded successfully. Wondering if this a known issue ?


Unable to open an Excel File in Sharepoint MOSS 2007


I am unable to open an excel file in Sharepoint (MOSS 2007). All other documents work fine. As far as I know there was no change on the Server at all.

Excel found unreadable content in 'stuff.xls'. Do you want to recover the contents of this workgroup? If you trust the source of this workbook , click Yes

When I click YES >> It says "Excel recovered your formulas and cell values, but some data may have been lost." And then a link to an xml file , which reads :

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <summary>Errors were detected in file 'http://server_name/Project_name/Shared Documents/abc - def/Phase 5/Track/stuff.xls'</summary>
- <additionalInfo>
  <info>Excel recovered your formulas and cell values, but some data may have been lost.</info>

Now this has resulted in huge loss of data and I can see New numbers in the cells which is very strange!

Is there a way I can get it back ? I do not have a

Unable to open the physical file. Using Asp.net Forms and VB.net Project



I Hope I can explain and express this well.. I'm getting tired figuring out this error. Well, Basically. I have uploaded my ASP.net website to a server (IIS installed) as well as the VB project I made.

BOTH are connecting to a DB named CLIENTS.

the website uses a datagrid to show data, while the VB Project updates the DB based on a monitored folder.

The Problem is If the website is opened first the VB project shows an error "Unable to open the physical file (MDF). Operating system error 32 (error not found)"

and Vice Versa if the VB project is first started.

Please Help.

Unable to open xls file in edit mode.


XLS files that I have created in office 2007 and saved down to 2003 format cannot be opened in edit mode by some users who have office 2003.  Trying to open from Sharepoint site with server version 2007.  Versioning is on.  Check out is required.  They have the appropriate permissions as contributer.  Any ideas?  I had them run this thinking it would help, but no dice.  "Go To Start > Run > Type webfldrs.msi

Click on Select Reinstall Mode button (not Reinstall button)

Select all options

Click on OK

Now click on the Reinstall button

unable to open the physical file operating system error 32


I have installed Sql Server 2005 with an instance name.

I am able to login using SQL Management Studio.

When i try to connect using Visual Studio through database explorer (its a VSTA for infopath), I get the error unable to open the physical file operating system error 32.  I am struggling to slove this. 

Any help in this regard would be helpful.

Thanks and Regards,

unable to open file Obj/debug/application.g.resources


When I started a new WPF Application and build it without modifying anything on it  I am getting an error BC31027

Unable to Open file WPFApplication1/obj/Debug/wpfApplication.g.resources : System Error &H80070002&

When I build an existing application which was working fine it thows the same exception 

But when I start a new windows application and build it , it just works fine

Need Oracle Data Provider .CS File for Oracle 10g Database connection !



I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query


Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");


Plz Post the link if there is any open source !    

convert SQL data to EDI 835 file


I was assigned to create a app to convert SQL data to EDI 835 file. (Electronic Data Interchange file for Health Care Claim Payment/Advice,  outbound process only).

Can someone help me where to start?

Merge SQL to Excel--Need .Net button to open on fly and have current SQL data!


           Hello all,
I do not know if this is the proper place to ask this, but my question is...
I have a SQL DB and I want to convert it to Excel Sheet (I did this using the wizard)!
In my aspx page I have a button.  So when I press this button I want the Excel sheet to open!  But I need the Excel sheet to show me the up to date information that is in the SQL DB.  

Practical OData: Building Rich Internet Apps with the Open Data Protocol


See how you can build Rich Internet Applications that take advantage of the OData protocol to creatively interact with Silverlight, PowerPivot, SQL Server, SharePoint, the Windows Azure platform, "Dallas" and more.

Shayne Burgess

MSDN Magazine June 2010

Cutting Edge: Customize Your Open File Dialog


Displaying an Open File dialog is certainly easy in the Microsoft® . NET Framework with Windows® Forms, but the resulting window is not as customizable as when you create it through the Win32® API. With Windows 2000, Microsoft added a nice feature-the places bar, which is the vertical toolbar that appears on the left side of the window to let you select a frequently visited folder.

Dino Esposito

MSDN Magazine March 2003

Unable to open pdf from document library MOSS 2007


When I click on a pdf document uploaded in a document library it comes up with a blank page. 

I guess it's trying to open pdf on the browser. I turned off "Display PDF in browser " option in Adobe Preferences, but it doesn't help, same issue.

I tried other browsers too, it's the same issue.

I am able to open all other pdf files local to my machine fine.

I am using IE 8 on my machine (Windows 7) and the Sharepoint server is MOSS 2007.



Cannot open data library in SPD2007


Help: For some reason, I'm unable to one of my data source library - sharepoint list i SPD.

 I can see the sharepoint list but when I select the list "show data" I get an error on the "Data Source Details" tab.

"The server returned a non-specific error when trying to get data from the data source. Check the format and content of your query and try again. If the problem persists, contact the server administrator."

When I open the list directly in IE it sees to work just fine, I see not problems there. When I open a customized view form (aspx) it fails.

If I try to create an new apsx and insert data source control for the sharepoint list, then I can see the fields in the list when I open properties on the data source.

If I insert a sharepoint control "custom list form" then I can see "preview" data from the list.

Does anyone have a clue why not I or anybody else can't open that list/form and data library?

Using SPD2007 and WSS 3.0, the SQL server is sqlexpress 2005 and is installed on the SP server

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend