I am tryng to implement the filestream feature provided with sql server 2008. After writing to the file stream file using win32 API i am trying to commit the transaction . Upon doing so i am getting the following error "An uncommittable transaction was detected at the beginning of the batch. The transaction was rolled back. This was caused by an error that occurred during the processing of a FILESTREAM request in the context of this transaction.
" I am hitting the remote server where the filestream data is saved.
I checked the @@TRANCOUNT inside my transaction and it showed as 1. I assume this means that there is only one transaction.
I am using c# code to write the file stream file to the path got by column.PathName().
The brief steps are as given below:
1)Hit the DB and get the UNC path of the file. The server is remote and not local.
2) Begin a transaction.
3)Get the transactional context by using GET_FILESTREAM_TRANSACTION_CONTEXT().
4) Write some data to filestream.
5)Commit the transaction.
I am getting the error when i am trying to commit the transaction.
I checked the path where this file is stored and a new file with the data i have written is created, but it is not getting reflected in my datarow as the transaction is not committed.
The code goes as
View Complete Post