How insert a blob in SQL Server without bulk and using ASP?

Question

I need to upload files 'into' a SQL Server database.

I need a solution that doesn't involve bulk inserts.

The Google search is a bit difficult, but this link looks promising: social.msdn.microsoft.com/forums/en-US/sqlexpress/thread/…, using ordinary ADO.NET. — Robert Harvey
– Robert Harvey, Commented Feb 16, 2011 at 14:59
Then you need to be searching for VBSCRIPT or VB6 code. Something like this: xtremevbtalk.com/showthread.php?t=169654 — Robert Harvey
– Robert Harvey, Commented Feb 16, 2011 at 15:19

celsowm · Accepted Answer · 2011-02-16 15:39:47Z

2

Set ObjStr = Server.CreateObject("ADODB.Stream")
ObjStr.Type = 1 'AdBinary
ObjStr.Open

ObjStr.LoadFromFile "D:\file.pdf"

'Evita sql inject
Set oPreparedStatementADO              = Server.CreateObject("ADODB.Command")
oPreparedStatementADO.ActiveConnection = conexao
cSql = "INSERT INTO edital_editais(blob_field) values (?); "


oPreparedStatementADO.CommandText = cSQL

x = ObjStr.Read

oPreparedStatementADO.Parameters.Item(0) = x

set rs = oPreparedStatementADO.Execute

answered Feb 16, 2011 at 15:39

celsowm

47410 gold badges43 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How insert a blob in SQL Server without bulk and using ASP?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related