Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

insertin BLOB in to database?

Status
Not open for further replies.

nowayout

Programmer
Feb 25, 2003
364
US
Hi I am trying to insert a blob in to database so for that the datafield and datatype are DFile and image. but now the table option should text in row "ON" or "OFF" i don;t know. What should it be.

Thanks
 
Unless your blobs are very small (under 8k) setting it on will not do you any good. Store image in row attempts to store small text and image fields in the database row instead of the default way (in a separate part of the database)
 
the blob are big which is in MB or may be higher but what should i do for that?
 
From what I've read, you shouldnt store blobs in the database. Instead, store a link to the blob.

We're storing blobs in the database, Not good, not good at all. But too late to go back.
 
yeah i am on the same side of the cliff too that it's too late to change it so what should i do about it. would you guide me please..

Thanks
 
The error i am getting is
"SQL SErver Message 7139: Length of text, ntext, or image data (374738) to be replicated exceeds configured maximum 65536"

How can i solve this error? please help me!!!

thanks
 
This will correct your problem ... check out BOL.

sp_configure 'max text repl size','393216'
go
reconfigure with override
 
where do i have to run this on the db which i am wokring on?

thanks
 
You can run this in a QA session on the server that your datbase is running on. This is a server configuration setting, and not database specific ... give it a try. Note that the size parameter is adjustable to fit your specific needs. You can set it to what you feel is appropriate.

Doug
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top