Get File Info


hello,

i saving, in sql table, files of various types:

image/jpeg, image/gif, application/pdf, audio/mpeg, text/css, text/plain, etc.

 

later retrieving files database.

i need stream following properties:

1 - mime type.

2 - length.

3 - height , width if file image.

 

is possible?

or need save info in database?

 

thank you,

miguel

i save these individually, make things easier on you. have these columns {filename, file, filelength, filedimensions}
john grove, mcc - senior software engineer


Visual Studio Languages  ,  .NET Framework  >  Visual C#



Comments

Post a Comment

Popular posts from this blog

BizTalk Server 2013 Azure VM Log Shipping and HA for hosts

hi , background: for our customer, having a  2 biztalk , 1 sql setup of environment. [biztalk server 2013 azure vms provisioned azure gallery, sql server 2012 azure vm ]. in current configuration, there no high availability or disaster recovery plan set. want implement dr , possibly ha configuration on these servers. i have few questions regarding same. please let me know thoughts on same. currently writing log files (log shipping files) mounted/attached drive same sql server. how move these log files across secondary site since shared storage not supported. in case of sql server crash, losing log files since reside on same server. please share options on how can move these periodically between datacenters. for hosts pop3, ftp need host clustering (which requires biztalk machines present on windows cluster traditionally), please let know how achieve in azure scenario thanks , regards, ujjwal devarapalli -ujjwal you can refer article, issue azure vm lo...
Read more

wcf-sql adapter bug for operation on same table

hi experts, first of explain u module.. 1.) inserting xml files in sql 2008 using wcf-sql adapter through an orchestration.. 2.)am retrieving records same table using wcf-sql adapter. here polling records directly admin console... my problem ,for first time records inserted , second time they going dehydrated stage... when disable receivelocation(polling table), records being  inserting without dehydration..after r&d come know problem exists because, am inserting & retreiving data same table..i think locking database at polling time.what solution this? can 1 faced same problem?is wcf-sql bug?is there solution to overcome problem?needed urgently pls based on scenario you've described, dirty reads out (since want update on records retrieved).   so you've got options here if looking configuration based solution .   if data you’re polling on can near real time, can set polling interval in 8-10 minute rang...
Read more

Error connecting to Azure Blob using Shared Access signature

msg 105019, level 16, state 1, line 100 external table access failed due internal error: 'java exception raised on call hdfsbridge_connect. java exception message: parameters provided connect azure storage account not valid.: error [parameters provided connect azure storage account not valid.] occurred while accessing external file.' create database scoped credential azurestoragecredential identity = 'shared access signature', secret = 'abcdexxxxxxxxxxxxxxxxxxxxxxxxx'; create external data source myazurestorage1 ( type = hadoop, location = 'wasb://container@mydwblob.blob.core.windows.net/', credential = azurestoragecredential ); create external table dbo.myexternaltable( vendorid varchar(50) null, ) ( location='/2016/', data_source = myazurestorage1, file_format = myfileformat,reject_type = value,reject_value = 1000 myfileformat,reject_type =...
Read more