Stack Overflow
Stack Overflow

Questions tagged [sqlfilestream]

SqlFileStream is a class that exposes SQL Server data that is stored with the FILESTREAM column attribute as a sequence of bytes.

The SqlFileStream class is used to work with varbinary(max) data stored with the FILESTREAM attribute in a SQL Server 2008 database. You must install the .NET Framework 3.5 SP1 (or later) to use System.Data.SqlTypes.SqlFileStream to work with FILESTREAM data.

Specifying the FILESTREAM attribute on a varbinary(max) column causes SQL Server to store the data in the local NTFS file system instead of in the database file. Transact-SQL statements provide data manipulation capabilities within the server, and Win32 file system interfaces provide streaming access to the data.

MSDN doc

102 questions
0
votes
1 answer

Filestream and using bulk insert via OPENROWSET gives File could not be opened. Operating system error code 50(The request is not supported.)

I felt in love with the filestream capacities of SQL Server giving the possibility to see only files and skip the complexity of hierarchies. When I import a xml file in a table using openrowset I get this error: INSERT INTO tblXmlFiles(IdTache,…
rvunen
  • 1
0
votes
0 answers

IIS-10 worker processes crashing

We recently upgraded our server O/S from Win2012 to Win2019. While on 2012, in IIS, we had configured a Virtual Directory called PDFReader. The physical path was a filestream directory which contains a series of PDFs, which is essentially just a UNC…
mmostwill
  • 31
  • 1
  • 5
0
votes
0 answers

SQL Server FILESTREAM - getting error 0xC0000148 when trying to create a FILEGROUP with CONTAINS FILESTREAM

I am trying to create a database with FILESTREAM attachments but getting a strange error when doing so. Msg 5120, Level 16, State 106, Line 14 Unable to open the physical file "C:\Program Files\Microsoft SQL…
komodosp
  • 3,316
  • 2
  • 30
  • 59
0
votes
1 answer

SQL Server Filetable in different local disk

Can I change filetables share disk? I've enable filestream on my db with a script like this DECLARE @dbName varchar(50), @pathFileStream varchar(max), @directoryNameFS varchar(max), @sql …
cirio
  • 11
  • 1
  • 4
0
votes
0 answers

SQLFilestream - Linq to SQL class or SqlConnection

I've been using LINQ-to-SQL class (.dbml) in my WPF/C# application to query and manage data saved in SQL server, and it has been working well. Recently we have an increasing need of saving files so I started to look at SQL Filestream. I'm very new…
Qing Ju
  • 23
  • 3
0
votes
0 answers

My Web application Becomes Unresponsive During large (300 mb+)File Download getting ByteArray saved in Sql DB and using Response.flush in C#

I gave source to download Iframe with input parameter in querying over there after fetching the query string parameter on PageLoad Download method is called. In download Method a wcf service is called to fetch the data of file from sql DB in byte…
Hari
  • 11
  • 1
0
votes
0 answers

SQL Server filestream: how to read csv into table

I copied a .CSV file dataset_with_pred2.csv into the filestream folder in SQL Server. Is it possible to read it into table? Now, everything I can do is to retrieve the .csv file into string via: select cast(file_stream as varchar(max)) from…
Alex Ivanov
  • 657
  • 1
  • 8
  • 17
0
votes
1 answer

Enable File Stream SQL Server 2017

I am trying to enable file stream on Microsoft SQL Server 2017, on a Windows Core 2019 Server. I have changed the registry settings at the following location to enable it as there is no GUI. I set the value to…
Lord Darth Vader
  • 1,895
  • 1
  • 17
  • 26
0
votes
1 answer

Pass byte array back to its original file from sql filestream

I have setup filestream on my mssql server, and it works pretty well thus far. Currently, I have one entity in my database, that I have added manually. When I added my file, it was automatically converted to a byte[], which Similarly appears as a…
Jeppe Christensen
  • 1,680
  • 2
  • 21
  • 50
0
votes
1 answer

Getting error creating new SqlFileStream object when SqlDataReader returns too many records

I am trying to access several files in a SqlServer FILESTREAM table. This code works when the number of files returned by the SqlDataReader is relatively small. About 20 Files. However, when the SqlDataReader is returning a few hundred records, I…
Battosai
  • 1
  • 3
0
votes
0 answers

Changing a file-stream file group on an existing table in SQL

I'm implementing the file stream in my database for the first time and I need to write a script that is going to change the file-group of file stream in a specific table. I was trying to work with the solutions that I found on the internet like…
Endrit Sheholli
  • 101
  • 1
  • 3
  • 19
0
votes
0 answers

Can Not Enable To FilleStream

I have sql server v2016 on windows server D V2016 . i can not enable to FileStrem.error Code (0x80041001)
AAA
  • 21
  • 6
0
votes
0 answers

Conditions for using FIlestream

I want to rent a dedicated Server for my company with the newest Microsoft SQL-Server on it and I want to use filestream to store some PDF Files within the SQL Server. I have read "Windows only" on the official Microsoft site and I am wondering if…
P.Weg
  • 77
  • 1
  • 8
0
votes
2 answers

how to stream video in asp.net core web API on Android?

How can I implement api with c# filestream or sql filestream in asp.net core to show video on Android? Has a good speed Secure And optimal server resources I use the jwt token for Android app communication and asp.net core api Please introduce an…
sbr
  • 167
  • 1
  • 2
  • 11
0
votes
0 answers

Store File in Database Server as FILESTREAM

I've used below link to create demo application to store files into database server as FILESTREAM, but in this scenario Web server and database server are on same machine. This is working as expected in local…
Abbas Panjwani
  • 81
  • 4
1 2 3 4
5
6 7