Displaying Images from Databases on ASP Page

[Ashish Sharma]

have been searching for two complete days now on how to
display images from a database on the webpage using ASP.

I found a script giving some details that I need to create
an ActiveX dll which I did. Then did all the neccessary
examples of how to impleement it in ASP.

However it still does not run. The instructions did not
tell me anything as to where I should put the dll file. I
tried by putting it in the same folder as the scrip and
then in Winnt but both did not work.

It is a simple affair. Make a connection to the database,
get the image, and display. The Active X part comes in
because of the additional header info that was placed with
the image when it was stored in the database.

I have followed the exact examples as shown by microsoft
but it doesn't work! I even used the same sample northwind
databse as them but even then no positive results.

And I have struggled with it so far, now it doesn't seem
to be worthwhile giving the idea up.

What I have deduced is that maybe the dll has not been
properly registered and that is why it does not allow the
createobject thing to execute.

Can you help please.

The instructions are at
[url]http://support.microsoft.com/default.aspx?scid=kb;en-[/url]
us;175261

Ashish Sharma
Computer Programmer
Information Technology Services
Fiji School of Medicine
Ph: 3311700 ext 1503 Fax:3303469
Email: [email]a.sharma@fsm.ac.fj[/email]

[Jason Melville]

Ashish

CreateObject failing is often a case of the dll not being registered.
Providing your code and database are fine simply place the compiled dll in a
sensible place (this can be anywhere, does not have to be in the WinNT
folder) and then use regsvr32 to register it.
This is done by either going to start - run or the command prompt and typing

regsvr32 <pathtodll>

This is the full path - i.e. regsvr32 c:\myProject\Bin\MyDll.dll

If you need to recompile the VB at any time try and set binary compatibility
to the dll so you do not end up with multiple registry entries. If you have
already compiled a number of times, or you still have problems try
downloading regClean or similar.



"Ashish Sharma" <a.sharma@fsm.ac.fj> wrote in message
news:191e01c37356$c029c350$a301280a@phx.gbl...

> have been searching for two complete days now on how to
> display images from a database on the webpage using ASP.
>
> I found a script giving some details that I need to create
> an ActiveX dll which I did. Then did all the neccessary
> examples of how to impleement it in ASP.
>
> However it still does not run. The instructions did not
> tell me anything as to where I should put the dll file. I
> tried by putting it in the same folder as the scrip and
> then in Winnt but both did not work.
>
> It is a simple affair. Make a connection to the database,
> get the image, and display. The Active X part comes in
> because of the additional header info that was placed with
> the image when it was stored in the database.
>
> I have followed the exact examples as shown by microsoft
> but it doesn't work! I even used the same sample northwind
> databse as them but even then no positive results.
>
> And I have struggled with it so far, now it doesn't seem
> to be worthwhile giving the idea up.
>
> What I have deduced is that maybe the dll has not been
> properly registered and that is why it does not allow the
> createobject thing to execute.
>
> Can you help please.
>
> The instructions are at
> [url]http://support.microsoft.com/default.aspx?scid=kb;en-[/url]
> us;175261
>
> Ashish Sharma
> Computer Programmer
> Information Technology Services
> Fiji School of Medicine
> Ph: 3311700 ext 1503 Fax:3303469
> Email: [email]a.sharma@fsm.ac.fj[/email]

[Jeff Cochran]

On Thu, 4 Sep 2003 19:38:12 -0700, "Ashish Sharma"
<a.sharma@fsm.ac.fj> wrote:

> have been searching for two complete days now on how to
>display images from a database on the webpage using ASP.

Did you see:

[url]http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=172[/url]
[url]http://www.4guysfromrolla.com/webtech/060100-1.shtml[/url]
[url]http://www.ammara.com/support/kb/showkb6258.html[/url]
[url]http://www.actionjackson.com/asp/examples/pubssql/pubssql.asp[/url]
[url]http://www.aspalliance.com/stevesmith/articles/imagequery.asp[/url]

That's just the first page from a Google of "asp display images from
database"...

>I found a script giving some details that I need to create
>an ActiveX dll which I did. Then did all the neccessary
>examples of how to impleement it in ASP.

You shouldn't need an ActiveX component just to pull images from a
database and show them on a page.

>It is a simple affair. Make a connection to the database,
>get the image, and display. The Active X part comes in
>because of the additional header info that was placed with
>the image when it was stored in the database.

What extra header info? And what image format? GIF/JPG are a breeze,
others may require a component to display.

>I have followed the exact examples as shown by microsoft
>but it doesn't work! I even used the same sample northwind
>databse as them but even then no positive results.

Doesn't work as in smoke started pouring from your server or was there
an error message displayed you neglected to tell us about?

>And I have struggled with it so far, now it doesn't seem
>to be worthwhile giving the idea up.

The process is actually quite simple. Images can be stored in a
database or the URL of the image can be stored to save space in the
database. If the former, it's not hard to retrieve the record and
display the image, and the links above will show you how in about ten
lines of ASP/VBScript.

Give them a try, especially the 4guysfromrolla one. Those tutorials
are usually complete and simple to follow.

Now, when you can display those images in a scrollable DHTML layer
with links, that's something more useful. :)

Jeff

[Exponent]

If you can possibly avoid it, don't use Access 'OLE Embedding' to store the images - just store the raw
binary data. Then there are no headers to deal with, no components required, etc.

The sample below can be placed on your webserver and should run without any further configuration. The
source files are also viewable from this page:

[url]http://www.ammara.com/support/samples/showsam475d.html[/url]

--
__________________________________________________ _____
[url]http://www.ammara.com/[/url]
Image Handling Components, Samples, Solutions and Info






"Ashish Sharma" <a.sharma@fsm.ac.fj> wrote:

> have been searching for two complete days now on how to
>display images from a database on the webpage using ASP.
>
>I found a script giving some details that I need to create
>an ActiveX dll which I did. Then did all the neccessary
>examples of how to impleement it in ASP.
>
>However it still does not run. The instructions did not
>tell me anything as to where I should put the dll file. I
>tried by putting it in the same folder as the scrip and
>then in Winnt but both did not work.
>
>It is a simple affair. Make a connection to the database,
>get the image, and display. The Active X part comes in
>because of the additional header info that was placed with
>the image when it was stored in the database.
>
>I have followed the exact examples as shown by microsoft
>but it doesn't work! I even used the same sample northwind
>databse as them but even then no positive results.
>
>And I have struggled with it so far, now it doesn't seem
>to be worthwhile giving the idea up.
>
>What I have deduced is that maybe the dll has not been
>properly registered and that is why it does not allow the
>createobject thing to execute.
>
>Can you help please.
>
>The instructions are at
>[url]http://support.microsoft.com/default.aspx?scid=kb;en-[/url]
>us;175261
>
>Ashish Sharma
>Computer Programmer
>Information Technology Services
>Fiji School of Medicine
>Ph: 3311700 ext 1503 Fax:3303469
>Email: [email]a.sharma@fsm.ac.fj[/email]

[Ashish Sharma]

Hey guys,

Thanks a lot man. I managed to get that sample application and golly, it
was just what I needed.

Once again thanks a million. I am a new member at this site but from now
on I'll contribute with what I know as well.

If you ever need any help regarding VB, Access or C++ or SQL, look me
up.

Once again: I am very grateful for your help. Thanks.




*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!