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

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

Bulk Copy From XML needs internet access???

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

I am using bulk copy in c# to import some data I exported from another SQL server.  Everything works fine until I no longer have the internet.  During the import it throws an error on all the data types.

I am exporting the data into an XML that includes the schema definition.  I then bring that into a DataTable with the schema definition and run SqlBulkCopy.

Why is SQL or c# trying to resolve the microsoft schema on import.  The schema came from the sql server?

This app has to work in isolation in some locations and this is a major show stopper.  I never thought that SQL could not handle its own schema definition during SqlBulkCopy.

Any help would be much appreciated.


View Complete Post

More Related Resource Links

Bulk Copy From Datatable To SQL Server Table


 I have read the data of a excle file and captured the data into the dataset to a datatable, now that data is to be inserted into a SQL Server table using bulk copy option. I am using -

 public bool BulkEnterData(DataTable dt, string tblName)
        SqlBulkCopy bulk = new SqlBulkCopy(con);
        bulk.DestinationTableName = tblName;

        return true;

ERROR Getting-
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) 

How to resolve the above problem or any other solution is available.


Bulk Copy Operations in ADO.NET 2.0


Bulk copying of data from one data source to another data source is a new feature added to ADO.NET 2.0. Bulk copy classes provides the fastest way to transfer set of data from once source to the other.

Each ADO.NET data provider provides bulk copy classes. For example, in SQL .NET data provider, the bulk copy operation is handled by SqlBulkCopy class, which is described in Figure 1. As you can see from Figure 1, data from a data source can be copied to one of the four types - DataReader, DataSet, DataTable, or XML.

Creating and sharing new sharepoint site to internet, limiting user access

I am a new hire into an existing business as I.T. I know the networking, I know the computers. The owner now wants me to learn Sharepoint among some other things. They currently use WSS 3.0. I have been reading up on this for the last month. I think I am ready to extend the current site to make it an Internet site so the employees can login. Some other things we would like to do I have read up on and it looks like they can be done, things such as inventory tracking in collaboration with QuickBooks and creating a website / portal for clients to have a unique login on and can see the status of their jobs in custom SharePoint lists. As far as I can tell the clients need an AD account. However, apart from that I am not sure what to do. A little background.  The company has multiple clients, and we ship things out daily to those clients.  We use Sharepoint to track the status of the jobs as they progress through the stages ultimately going to delivery. There is one common page that lists all the jobs by all clients that is updated constantly. We would like to allow multiple (different) clients/logins and have a page customized for each client.  For example, you are a client and go to www.companyname.com/sharepointsite.html.  From there you would get to a portal page with a login. Once logged in you will be presented with the Shar

Access Denied/The workflow could not copy the item workflow error after Sharepoint 2010 upgrade

We have a sharepoint designer workflow that copies a document from one library to another on the same site.  Before the upgrade to 2007 it worked fine, but now with 2010 it gives an error and cancels the workflow when it gets to the copy list item step.   The error on the workflow page: The workflow could not copy the item. Make sure the source and destination lists have the same columns and column settings.  Access Denied   Specifically it is the "copy list item current item to documentlibrary" sharepoint designer workflow action.   I have given the system account full permissions to the library and double checked that all columns are the same in both libraries. These are the verbose trace logs:   09/01/2010 09:46:04.05 w3wp.exe (0x17C4) 0x093C SharePoint Foundation Workflow Infrastructure 72er Medium System.UnauthorizedAccessException: <nativehr>0x80070005</nativehr><nativestack></nativestack>Access denied. at Microsoft.SharePoint.SPFile.UpdateInternal(Boolean migrationSemantics, Boolean reGhost) at Microsoft.SharePoint.Workflow.SPWinOEWSSService.CommitCopyFile(Transaction txn, Object[] transData) 09/01/2010 09:46:04.05 w3wp.exe (0x17C4) 0x093C SharePoint Foundation Workflow Infrastructure 72fe High Error in commiting pending workflow batch items: Sys

WSS and Internet Access

I am trying to expose my intranet site running WSS 3/W2K3 R2 to allow internet users to access my site. The server is a standalone workgroup server, not part of a domain.http://mywss is an example port 80. Since I do not have a registered domain .com, .net, etc..; how can I expose and redirect through DNS or port 443. I do not have an ISA or proxy server, Just W2K3 with IIS. A few articles have referred to a reverse proxy solution using ISA. Can this been done in a simple way using IIS, DNS and opening a port in the Windows Firewall. Thanks for any input and instructions.  Hank FarlowHank Farlow

SP 2010 RTM: Volume Shadow Copy Service error: Access is denied


I'm getting this error on SP2010 RTM:

Volume Shadow Copy Service error: Unexpected error calling routine RegOpenKeyExW(-2147483646,SYSTEM\CurrentControlSet\Services\VSS\Diag,...).  hr = 0x80070005, Access is denied.

   Initializing Writer

   Writer Class Id: {35500004-0201-0000-0000-000000000000}
   Writer Name: SPSearch4 VSS Writer
   Writer Instance ID: {13687afd-3a26-4e72-a323-dda04d8c2066}


External Internet Access through a proxy server for RSS


I am trying to configure a Sharepoint 2010 farm (3 WFE and 2 AppServers) to load RSS content from the Internet, but our farm is behind a proxied firewall.  I have found instructions for configuring Sharepoint 2007 to be able to access the Internet through a proxy, but have found nothing for Sharepoint 2010.  Are there any new methods in 2010, or is it still modify each web.config file?  I was able to make this work on my test server with the same change as 2007 in the referenced discussion, but I'd rather not mess with the web.config manually if possible.  Any ideas or suggestions would be appreciated.

RE: http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/eff65c83-81e7-483f-b957-dc16a93090a7/

Bulk copy from SQL Server to a managed app on network.


I am dealing with a perf issue.

We have code (SQL CLR triggers) that can take a few changes from a table and send them over a network to a recipient server, this recipient caches the data in memory, and appears as a .Net collection to local apps running on the recipinet server (there is no SQL server running on the recipient).

As changes are made to the table in SQL server, the managed trigger gets these, packs them into a class we designed (that stores rows/columns and some other details) and then uses binary serialization to send them over the network, the recipinet server (a managed code NT service) deserializes and updates its local cached copy.

The network IO is done by our own simple classes that use TcpClient and so on.

As a trigger this works OK, so I leveraged the trigger code so that I can also use it to pre-populate the remote server, by "pretending" every row has been changed and just sending the data, so we use the C# trigger library as a bulk upload from SQL Server to our remote recipient.

But this is proving far too slow, I am still pinning down why and where, but suspect the network cost is high, 10 rows from a table with 10 columns ends up being sent as a serialzied blob 10,500 byte long, or about three times the size of the raw data bytes in the rows.

So our bulk upload is taking hours for ve

cannot access sharepoint site through Internet Explorer 8 on a machine running Win XP Service Pack 3


The Sharepoint portal can be accessed fine through Firefox. Opera allows me to access it, but I cannot sign out, check out a shared document or do anything which opens a small window on clicking an option.

I can stay with Firefox, but when I try to edit a shared Word document in Word I get the message "Edit document requires a Windows Sharepoint Services compatible application and Microsoft Internet Explorer 6.0 or greater" We need to edit a shared document/calendar which is uploaded. All I know is we are using Sharepoint 2007 and the version of our site is Does that mean we have Windows Sharepoint Services SP2 on our Sharepoint server?

When I try Internet Explorer, I cannot log on at all. I get a window which asks for my credentials which I enter, it fails to authenticate me, then shows me the You are not authorized to view this page message. I tried with different computers, but cannot get in using Internet explorer.

What could be the issue?

Our Sharepoint admin does not have time to look into such matters so I am on my own.

Any suggestions would be appreciated.

Setup to access moss 2007 externally when a proxy server is enabled on the internet connection



Does anyone know what setup is required to allow an internet connection with a proxy server enabled to authenticate properly with moss 2007?

The credentials dont get accepted at the moment and the screen goes blank (white) after the three attempts. I gather this has something to do with NTLM not being allowed throguh the proxy server which is the authentication method we have used at the moment.


Bulk Insert into Access Database not working for template fields in gridview



I have a gridview with 5 columns

4 are fetched from database through select command from table CSDB_MASTER

5th is a template field textbox which consists of value 3 by default

now i have a button down to the gridview with the following code below

everything is being inserted except the value of textbox, when i open my database the field NOC which should be inserted with grv.cells[5].Text i.e, the textbox value is null

Please Help Me Out in this issue


protected void Button1_Click(object sender, EventArgs e)

        OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\masterdb.accdb;Persist Security Info=False;");
        OleDbCommand cmd = new OleDbCommand();
        cmd.Connection = con;

        foreach (GridViewRow gvr in GridView1.Rows)

Bulk insert into access database not working with template fields in gridview


how to insert data into access database from gridview containing template fields

Microsoft SharePoint Access Over Internet



I'm making a standalone SharePoint site for my team. I have successfully configured SharePoint 2010 on a Windows 2008 R2 server. However, the problem is, I cannot connect to the server from any external computer. I'm a bit new to the SharePoint software, as well as the installation process. I'm not exactly sure what ports I should forward either. 

I would also like to know about the entire domain situation. Will I have to register a domain name? Can I use a Dynamic DNS server? 


Any help would be greatly appreciated. 


Thank you 

MVC architecture in ASP.Net using C# and Microsoft Data Access Application block

The Model-View-Controller (MVC) pattern separates the modeling of the domain, the presentation, and the actions based on user input into three separate classes [Burbeck92]:

Model. The model manages the behavior and data of the application domain, responds to requests for information about its state (usually from the view), and responds to instructions to change state (usually from the controller).

View. The view manages the display of information.

Controller. The controller interprets the mouse and keyboard inputs from the user, informing the model and/or the view to change as appropriate.

Store and Display Images from MS Access Database Using C#

There is only the difference of coding syntax to stream the binary data of image content type to upload it into MS Access Database using C#/VB in ASP.Net 2.0

Namespaces required:-
using System.Data.OleDb;

OleDb is used to connect the web site forms with MS Access Database using Microsoft.Jet.OLEDB.4.0

ASP.Net Upload Image to MS Access Database

As you learnt from the previous articles to upload image to the SQL Database in ASP.Net 2.0 and stream that image into the memory to retrieve it from the database and display it on the web page. In this article you will learn how to upload images to the MS Access database in ASP.Net 2.0

First of all create an Access Database and place it in the App_Data folder of ASP.Net web site project. Then create a table "tblImg" with the following fields:

Wrong Account being used to access files - Help - No Impersonation


I run a simple .aspx website on a Windows Server 2008 machine.

There is NO impersonation, and System.Security.Principal.WindowsIdentity.GetCurrent().Name returns NT AUTHORITY\NETWORK SERVICE, which it the account which the application pool runs. In my web.config, I have <authentication mode="Forms">.


I tried to test the security of the application and server by removing file permissions to the .aspx files. I was greatly worried when the website continued to run without problem (it should not have been able to read the .aspx files).

By turning on file level auditing, I discovered that the .aspx files were being read by the machine$ account (if the machine is called Serv1, then the files would be read by the Serv1$ account, which seems to have access to all files on the local machine).


Is this a security breach or is this behaviour by design ?

Please can somebody assist, as I am worried.

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