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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic Images From a Database 2

Status
Not open for further replies.

kjellanderton

Technical User
Jul 18, 2003
2
GB
This time I will go into more detail. I have a database of products. The database consits

of price, description and a photograph of the product. When dreamweaver extracts the

information from MS Access it has no problem with the text information, but the images of

the products which I have linked to the database appear in dreamweaver as either a brocken

image or dreamweaver simply wont make the recordset on the basis that it has a syntax

error.

This is how I linked the database to Dreamweaver. I installed a testing server (IIS) using

the wizard in windows xp. Then I created a database connection. I went into Administrative

Tools and clicked on Data Sources (ODBC). The ODBC Data Sources dialogue box appeared and I

choose the System DSN tab and clicked Add. A list of drivers appeared and I selected

Microsoft Access Drivers. I clicked finish and the ODBC MS Access setup dialogue box

appeared. I typed in a unique name and choose the database I wished to connect to. This

created the database connection.

Then I configured my web site to be dynamic within dreamweaver. I clicked site, edit sites.

The Edit sites dialogue box appeared and I clicked edit. Site Definition dialogue box

appeared and I choose testing server, ASP VB Script, local network, c:\inetpub\
and the url prefix is and click ok. I then click the application

panel and click + and select Data Source Name(DSN). The DSN dialogue box appears I typed a

unique connection name and selected the relavant DSN from the list and clicked test. A

dialogue box appeared confirming my connection. I then created a recordset for the data I

wished to extract from the database.

I have tried over and over again with all different sample databases trying to get the dam

images to appear in my web site. I create the databases in Access using the wizard.

Sometimes when I try to create the recorset and then test it I get this message -

[Microsoft][ODBC Microsoft Access Driver] syntax error in FROM clause.

When I try to create the recordset for other databases and test it, the Test SQL statement

dialogue box presents the image as ?$| and when you try to drag and drop the recordset into

an image place holder and preview it in the browser or in dreamweaver it shows as a brocken

image. The images are all gifs.

I don't want to simply put the images staight into dreamweaver because the pages will be

static and not ASP. Please Help.
 
Could you stick to one thread about the same problem please and post some code.




Chris.

Indifference will be the downfall of mankind, but who cares?
 
how do you store your images in Access - as BLOBs or links?
post asp code for displaying images also...

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top