kjellanderton
Technical User
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.
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.