Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Accessing FILESTREAM data from an SQL CLR assembly Expand / Collapse
Author
Message
Posted Saturday, October 20, 2012 10:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 11:07 AM
Points: 1, Visits: 37
I'm trying to stream FILESTREAM data from an unsafe SQL CLR assembly.

The connection string is "Data Source=LAPTOP2\SQLEXPRESS;Initial Catalog=test;Integrated Security=True;Enlist=False" but when creating a new SqlFileStream (inside an SqlTransaction, of course), I'm getting "The request is not supported" at OpenSqlFilestream.

So I decided to try native OpenSqlFilestream directly, but then I'm getting an invalid handle (-1) while GetLastWin32Error returns that same "The request is not supported" (ERROR_NOT_SUPPORTED). Have also tried SqlContext.WindowsIdentity.Impersonate() with no apparent effect.

I couldn't find any documentation referencing this restriction. Is it really unsupported? If unsupported, is there a good reason? maybe a workaround?
Post #1375112
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse