Solved

I need to connect to Microsoft sql server in Dream Weaver cs5 how can I do this

Posted on 2012-04-03
7
388 Views
Last Modified: 2012-04-11
I need to connect to Microsoft sql server in Dream Weaver cs5 how can I do this
0
Comment
Question by:1030071002
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 70

Assisted Solution

by:Jason C. Levine
Jason C. Levine earned 300 total points
ID: 37804538
What server language are you using?
0
 

Author Comment

by:1030071002
ID: 37804566
I am running microsoft sql server 2000 and I would like to utilize php in dream weaver cs5
to connect to the database and do some update , select or insert.
with the data the user enter in my html 5 form.
0
 

Author Comment

by:1030071002
ID: 37804567
i have already configure php cgi on my webserver which is iis 7
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 70

Assisted Solution

by:Jason C. Levine
Jason C. Levine earned 300 total points
ID: 37804590
Dreamweaver doesn't support MS SQL with PHP natively.  You can fake it with pdo_dblib

http://forums.adobe.com/thread/646336

has more information and links for you to follow.
0
 
LVL 16

Assisted Solution

by:glenn_1984
glenn_1984 earned 200 total points
ID: 37810518
Not sure what you want to do exactly.
To run php on Windows, download and install XAMPP (Free)

To put the code into DW CS5 to make it connect on your website see:

Dreamweaver Help / Connect to MySQL database in Dreamweaver:
http://helpx.adobe.com/dreamweaver/kb/connect-mysql-database-dreamweaver.html
0
 
LVL 70

Assisted Solution

by:Jason C. Levine
Jason C. Levine earned 300 total points
ID: 37814400
Glenn,

I think the asker is trying to use the built-in server behaviors with PHP and MS-SQL.
0
 
LVL 16

Accepted Solution

by:
glenn_1984 earned 200 total points
ID: 37816720
From Adobe Help:

Defining dynamic templates


You can create templates that are based on dynamic document types. These templates are called dynamic templates. The following two elements are essential to defining a dynamic template:

The value of the internaltype attribute for the new document type must be DWTemplate.
The dynamicid attribute must be set, and the value must be a reference to the identifier of an existing dynamic document type.
The following example defines a dynamic document type:
<documenttype
    id="PHP_MySQL"
    servermodel="PHP MySQL"
    internaltype="Dynamic"
    winfileextension="php,php3"
    macfileextension="php,php3"
    file="Default.php">
    <title>PHP</title>
    <description><![CDATA[PHP document]]></description>
</documenttype>
Now, you can define the following dynamic template, which is based on this PHP_MySQL dynamic document type:
<documenttype
    id="DWTemplate_PHP"
    internaltype="DWTemplate"
    dynamicid="PHP_MySQL"
    winfileextension="php.dwt"
    macfileextension="php.dwt"
    file="Default.php.dwt">
    <title>PHP Template</title>
    <description><![CDATA[Dreamweaver PHP Template document]]></description>
</documenttype>
When a Dreamweaver user creates a new blank template of type DWTemplate_PHP, Dreamweaver lets the user create PHP server behaviors in the file. Furthermore, when the user creates instances of the new template, the user can create PHP server behaviors in the instance.

In the previous example, when the user saves the template, Dreamweaver automatically adds a .php.dwt extension to the file. When the user saves an instance of the template, Dreamweaver adds the .php extension to the file.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Multiple row insert not working as before after applying hotfix apsb13-13 9 489
slider for the banner 2 319
I want to center my image horizontally with CSS3 8 469
CSS Layout Help 7 238
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

733 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