Solved

Connecting to Database?

Posted on 2000-03-13
6
145 Views
Last Modified: 2010-04-25
I would like to know if Dreamweaver will allow Database connection I have no Manual and the on-line help makes no mention of database connection.  I have a simple table in an access database which I would like displayed in a simple table through Dreamweaver.  Is it possible, where do I need to look for my answers???  Are there any good web sites?
0
Comment
Question by:mercia
6 Comments
 
LVL 17

Expert Comment

by:inthe
ID: 2614636
Hi
this lasso is about all you'll find at the moment:
http://www.blueworld.com/blueworld/products/

eventually there will be more when the extensions page for dreamweaver is finished.it will be here:
http://www.macromedia.com/exchange/dreamweaver/
0
 
LVL 17

Expert Comment

by:inthe
ID: 2616173
hello,

http://www.massimocorner.com/
click "dreamweaver" then "objects"
and scroll down to you see
"asp grid by Emmanuel"
this may be some help.
0
 
LVL 1

Expert Comment

by:cybernietic
ID: 2623338
You can add PHP extensions to  Macromedia's Dreamweaver.
With PHP you can easily create database connection

The url for the site is :

http://phpweave.quad-sys.com/index.htm

"One of the best server side scripting languages meets one of the best Win32 Grapical editors -- Phpweave is a set of commands and objects (DW parlance) to generate PHP3 code. It helps automate some of the code writing you tend to do over and over again. The completed code may be manipulated with DW GUI editor with only minor annoyances..."
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Expert Comment

by:nigelboyce
ID: 2664170
You can connect to most of the main dbms as well as MSAccess using Allaire's Cold Fusion.  The Objects for Cold fusion are already supplied with the Dreamweaver Package.  A 30-day demo of Cold Fusion can be obtained from www.allaire.com
0
 

Accepted Solution

by:
krirob earned 50 total points
ID: 2699584
You can not connect to a db by default in Dreamweaver you have to use some server side script like PHP, ASP, JSP, ColdFusion and so on. And the webserver needs to support MSaccess and the server side script language.
0
 
LVL 1

Expert Comment

by:billd1
ID: 2734594
Although this is locked, I feel that you guys might be getting too technical for something easy here.  My thoughts are what are we trying to accomplish here?  Are you looking for a static web page of Access data, or are you looking to pull "live" data from the database on yor web server?  Either way, you really don't do this inside Dreamweaver.  I don't think that Macromedia and Microsoft products of such different purpose would communicate that well with each other.  Basically, the way you shoudl approach this(given I know nothing of your end result or versions of your applications), is actually coming from Access not Dreamweaver.  In Access, create your table or your queries depending on what data you are looking for. Save those items, and then use Save As HTML(97), or Save As/Export(2000) to spit them out as web pages.  Now, if you are simply looking for static data, then just go through the steps, and set it for HTML, and throw the new web page or your site and link to it.  If you are looking for live data, then it's a little different.  
First, are you doing this on your ISPs server or on a local IIS server?  Either way you'll need a System DSN setup for this database.  For a local server, you want to go into the ODBC Data Sources in the Control Panel, and setup a System DSN for the database on the server.  Remember to record the datasource name.  Again, working back through the "Save As.." feature in the database you would want to select IDC/HTX.  This will then prompt you for that data source name that I told you to record from the System DSN setup.  This IDC file is the file you link to from your pages.  And like so many other pages that pull data from whereever, you MUST follow the link with a question mark(?), in order for it to work.  If this is on your ISPs servers, I would contact them about what they support and can do to setup a System DSN for it.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question