View blob on web

Magno

Hey,

This is our situation:
Navision 4.0 on SQL Server

We have an ASP Website running to let customers view the navision info(directly on the website)

Now, i also want them to be able to view images stored in a blob. As i understood, the blobs are saevd in a compressed way, so i can not just show them on the website.

Can i in my ASP Pages uncompress them, or is there another way to do this?

nunomaia

Directly access to Blob’s in SQL without Navision involvement it’s complicated. One of the solutions used by MS Commerce Portal is to store the images in files.

To access directly it’s better to use NAS as middleware.

Ravi_Thakkar

Hi Magno..

I am also facing the same problem.
Did u solved ur problm..?
If yes then please suggest me how to do the same.
And further I am also uploading the file from web to navision. for that also i have the same problem.

Please help me for this problm.
Thanks in Advance.

nunomaia

Remove compress BLOB property and you can read from directly.

Ravi_Thakkar

Hi nunomaia,

Thanks for your valuable Reply...
I have already set that property. I have used 5 fields in navision table.
1) File Name - text
2) File Size - integer
3) Content Type - text
4) File Data - BLOB
5) File Path - text

I am attaching one file from asp.net web-application.
I am getting value in all fields. but when i mretriving that file then it only displays file with data "System.type[]"
i.e. it is attaching the file but not the file data.

If you have any idea regarding this issue then please reply me asap.

garak

The BLOB in Nav are compressed (Property on BLOB field). So you must change this property to NO.

But note, BLOB makes a database "full" and NAV ever reads this blobs (fieldlenght).

So, why do you not store only the UNC Path (\\Server\Path\Filename.extension) in a seperate field and from your website you call the picture, pdf, document, exe, or what else from the path (the info you get from the Navsion field) :?:

With this solution (here you need a separate table) it is also possible, to store more information documents for an (example) item.
Like a photo / photos, product documents, or what else.

Regards

Ravi_Thakkar

Thnks a lot for your reply,

Recently I have solved my problem...
Now I can easily attach any files to navision database from asp.net application and also can do reverse.....

Thanks again to all of you....