.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

OLEDB: Send BLOB data into MSSQL in transaction

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

I am sending data into blob (varbinary) column in MSSQL database using OLEDB in MFC (my previous question: question). I am using this code: code and this example code: example

Sending is going fine, but when I want to insert rows in transaction, it freeze. I know reason, bu don't know solution.

The idea is that I insert row into database, get id of the new row by SCOPE_IDENTITY and (using code from previous articles) update blob column. But when I do it in transaction (just executing BEGIN TRANSACTION and COMMIT TRANSACTION command), it freeze. It is because to upload BLOB data it is necessary to create new connection.

The question is: How to send BLOB data into MSSQL in opened connection (and session)? Because I want to send lot of new rows in one transaction.

To open connection and session I use 


To execute SQL command I use:

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 9.5px Consolas}


View Complete Post

More Related Resource Links

writing BLOB data with OLEDB



I got a problem writing data to the DB when it comes to long data types. So here is the Situation: I have to integrate support for column of type "ntext" to our database interface. I already read a lot through the msdn and i also got a few samples that work but they all use different methods.

We use IRowsetUpdate interface (most of the samples i found use IRowsetChange)

Writing the data to the binary buffer works. I can read it from the binary buffer after writing it to the binary buffer in the same way i read out data that already is in the database. So this is obviously not the problem. The Object settings in the bindings is also correct and looks like this:
aBinding[nColCount].pObject = new DBOBJECT;
aBinding[nColCount].pObject->iid = IID_ISequentialStream;
aBinding[nColCount].pObject->dwFlags = STGM_READ;

Where the Problem occurs:

When i insert a row using an empty cursor a row is inserted into the DB but the ntext column is empty, not null, but empty (my test table has 2 columns, a primary index of type int and a ntext column)
I don't get an error here. Inserting looks like this:
CComPtr<IRowsetUpdate> pRowUpd;
m_pRowset->QueryInterface (IID_IRowsetUpdate, (void**)&p

Insert data to Excel using OLEDB



I am trying to insert data to Excel Document using OLEDB as follows:-

 sql = "Insert into [MyFirstSheet$] (" + Title1 + "," +Title2 + "," + Title3 + ") 
values('" + Value1 + "','" + Value2 + "','" + Value2 + "')";
myCommand.CommandText = sql;

 sql = "Insert into [MyFirstSheet$] (" + Title1 + "," +Title2 + "," + Title3 + ") 

values('" + Value1 + "','" + Value2 + "','" + Value2 + "')";

myCommand.CommandText = sql;


But, the Title1 ,Title2, Title3 are in the 3rd row of the Excel Document. So, the data is not inserted.

Collaboration Data Objects: Send Microsoft Exchange Appointment Reminders to Your Pager Using CDO


Besides your typical e-mail services, Microsoft Exchange also provides the service infrastructure you need to build extensible knowledge and workflow management systems. Understanding Collaboration Data Objects (CDO) is the key to accessing these Exchange services for your own programs. With CDO you can automate tedious tasks and integrate information such as e-mail, calendars, and contacts with almost any application. This article explains how CDO enables you to access Exchange services, then walks you through a sample application that reads calendar events from an Exchange server and sends pager reminders to your users.

Sean McCormick

MSDN Magazine June 2000

send data in class object from one page to another using session


hello everybody

now i hav stored all data like user name, data fatched from database of that user

and i stored that data and user name such as:

string strUserName="user name"

dataset ds =new dataset();// data of that user

now i wan yo send d whole data from my login page to user profile page

can anybody help me for that...................

and plz tell me that how much is this way is benifitial to send data from one page to another page

plz........kindly waiting for positive rply

Send an Email with User fields data entered in the form


Hi All,

          I have a form which have some user input fields(like textboxes,dropdownlists,textarea etc) fields and a submit button.

on click i need to send email with body contents as all the details entered by user in the form

Can anyone suggest how i should approach to this in sharepoint..

any code examples would be appreciated.


Estimate weight of BLOB data in our content database

How can I estimate overall size of blob data?

Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint Server

Learn how to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Sample: Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint

Download sample code as you learn to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

System.Data.OleDb.OleDbException: Could not find installable ISAM.


Hi, i got the following error while i am trying to get my web application to run on windows server 2003. I've installed 2007 data access components on windows server 2003 but the web application does not seem to work. The codes that i use is as follows:

string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + address + ";Extended Properties=Excel 12.0;"; OleDbConnection objConn = new OleDbConnection(strConn); string strSQL = "SELECT * FROM [Sheet 1$]"; OleDbCommand objCmd = new OleDbCommand(strSQL, objConn);

OleDbDataReader oddReader = null;


oddReader = objCmd.ExecuteReader();







I've read a lot of forum posts and almost all of them mentioned ab out the connectionstring being wrong. However, when i ran the codes on my local machine, there were no errors. The error only show when i was running on windows server 2003.

I've underlined where the error is pointing to. Please advise. Thanks

How to send data from WPF UI to excel file?

How to send data from WPF UI to excel file? Thanks.

Read data from BLOB field and write to sharepoint list

Hi, I want to read the data from BLOB field and write it into sharepoint list item. Please provide some pointer to archive above objective.   Thanks in Advance.

Sys.Data.DataContext.saveChanges method doesn't send update to server after DataServiceException ex

Hello,I have a page with a simple form that updates a single record in a table in my database.The database is accessed via WCF Data Services. To load and save data from/to the server, I usethe Sys.Data.DataContext object provided by the ASP.NET AJAX library. When the "save" button on theform is clicked, I use the saveChanges method of the Sys.Data.DataContext object to send all changes to the server.Also, at the server side, I use an interceptor that checks the "Price" fields of the record, and throws a DataServiceException exception when the contents of the field is a negative number.Both the JavaScript and the interceptor (in C#) are copied below.Here is the interesting thing:When I enter a negative price in the form, the interceptor throws the exception and my form shows an error message. Good.However, if I then make one of the other fields in the form a bit shorter (for example from "abcd" to "abc"),the saveChanges method doesn't send the data to the server. But it does call the success callback that I passed in to saveChanges, creating the impressionthat the data has been saved. This happens while the Price field is still negative. I used Fiddler to make sure thatno message is sent to the server. Also, the interceptor doesn't get executed.The weird thing is that if I make one of the fields a bit longer instead (for example &q

Reinitialize transaction replication clear the subcriber data and replicating again

Hi all, I add new table in to mu publisher database and reinitialize the subscriber.And i select the option to create new snapshot and marked as reinitialize.When it starts the reinitializing it clear all data from subscriber and coping again.Am i missing any thing here to add new table into existing replication ? Regards, Theesh

Best way to send data to report server from merge replicated database

Hi ALL,              I have merge replication configured on database say Testdb on production server. I want data from testdb(merge replicated) database to send to report server. How can i accomplish this....Whts the best way to send data at regular intervals to report server.. Any suggestions plz TIA

How to send data back to the datasource?

I have an ObjectDataSource which has two methods - GetData which gets data from the database and returns an array of Classes, and UpdateData which takes an array of Classes and updates the database.  The array of Classes contains sufficient information to allow UpdateData to work out what it needs to do.  So, to get an update to work, all I need to do is pass the [amended] array of Classes back to the ObjectDataSource via the UpdateData method. Then I have a control which inherits from DataBoundControl.  The control is happily using PerformSelect and PerformDataBinding to make the data available.  As it happens, I'm also implementing IScriptControl and throwing most of the data to the Browser as JSON for processing as a Javascript array.  I've got to the point where, on a PostBack, the data arrives back on the server and the control gets the array into the state where it is ready to update. Then, I need to pass the array of Classes over to the ObjectDataSource (the converse of the PerformSelect).  I was expecting to see a PerformUpdate or similar function within DataBoundControl.  At that point, I have juddered to a stop - and can't find anything which talks about how to get the data source to update. I'm, probably missing something obvious - and actually hope that I am! Thanks, Nick

Descompress BLOB data form SQL server into a file

Hello guys..... I have a question for developers in SQL Server. I need to migrate data from one table to another, i will use SSIS to do the job, i have no problem with this, but during the migration i need to read a column that contains BLOB data (documents .docx .xlsx .pdf etc) and generate and sownload the file in a folder directory. I need to implement this functionality into SQL entorn (SSIS package), do you know if exist any function in SQL that could do the job, or any extend functionality form .net that could be included or called from SQL SSIS in order to be executed? I will appreciate your support, thanks. PS        

putting data in a format send by email

Gooday If i want to send my data to someone by email so as they can update the data into their database , how can i do this . The database is too big to send by email? thanks Robrh
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