SysChat is a free online computer support community. Ask questions, share resources, contribute knowledge and discuss technology. Join our growing community to access all features. Register Now!

SysChat » Software Support » Operating Systems » plz reply its urgent!windows7,sql server and dreamweaver

Operating Systems

Support help troubleshooting and discussions on Operating Systems.

LinkBack Thread Tools
  #1 (permalink)  
Old 07-28-2011, 04:57 AM
blueplanet blueplanet is offline
Junior Member
Join Date: Mar 2006
Posts: 6
blueplanet is on a distinguished road

Default plz reply its urgent!windows7,sql server and dreamweaver

hi, i am working on a website which is in dreamweaver. I want to add a database page in it. I have windows 7 ultimate. I dont know which sql server version i shpould install in OS which is compatible and could also be easly connected with dreamweaver.
please reply as soon as possible have to submit the project.
If you also know any good website which guides how to connet that version(which you will recommend in windowx 7) with dreamweaver please let me know also.
Thanks for your time

Reply With Quote
  #2 (permalink)  
Old 07-28-2011, 02:12 PM
DominicD DominicD is offline
Senior Member
Join Date: Feb 2011
Posts: 251
DominicD is on a distinguished road

Server Database

hello blueplanet!

wow, you've got quite a question that's reminded me of fun times when i last worked with dreamweaver and php-mysql database here goes..

Well, depends on what you want to use..

If you want to go the Microsoft way, there’s always the free Microsoft “MSDE”. It’s Microsoft’s free version of an SQL database.

If you want to go the “free-open-source (FOSS)” path, you can easily download “XAMPP”. XAMPP is a compilation of FOSS projects, primarily it stands for Apache-MYSQL-PHP-Perl that is designed to easily run for Windows (or MAC/Linux). I use XAMPP for Windows because its easy to configure and understand.

XAMMP contains the Apache server -- you can use Apache if you do not have a web server yet, OR you can user Windows IIS is that is your preference.

XAMPP contains MYSQL – this is essentially an SQL database, so SQL commands and theories will work with MYSQL. Unless your project specifically needs the Microsoft branded “Microsft SQL Server 20XX”, you can settle with MYSQL or other free/paid SQL databases.

Download XAMPP here:

When you have XAMPP installed and running, you should see the XAMMP control panel similar to the one below..

Make sure that MYSQL server is running.

If you will be using Apache as the web server, then it should be running as well. If you are using Microsoft IIS or a different webserver, then disable the Apache server.


Some things to remember:

Enable these to have incoming and outgoing access on the Windows Vista/ Windows 7 Firewall:
  • Dreamweaver.exe
  • MySQL – mysqld.exe
  • Apache – httpd.exe

Remember to create a MYSQL account that has access to the MYSQL database which you’ll be working on

Now onto Dreamweaver + MYSQL..

Im using Dreamweaver 8, its an old version as of now, but configuring Dreamweaver with a MYSQL database should be of the same concept as below:
  1. Define a new “Site” in Dreamweaver

  2. Setup the other fields specific to your files location, and server info

  3. In the settings of the new site, make sure that the Testing Server is set to use PHP MYSQL

  4. Copy your static files (html, pictures and media etc) onto the folder location of the new Dreamweaver site.

  5. When you get to the page where you need to define a database connection, open Dreamweaver’s Database window. Go to Dreamweaver Menu – Window – Databases (or press Ctrl+Shift+F10). Click on the “+” sign to add a new database connection

  6. Input the details for connecting to your MYSQL database. The values here depend on the login account that you created on the MYSQL database itself.

    You can press the Test button to make sure that the login and database connection is correct. Click the Select button to select the database that you need to work on.

  7. The Database window of Dreamweaver now changes. Dreamweaver is now actively connected to MYSQL. You can view the three basic parts of your MYSQL database – stored procedures, database tables, and your custom database view.

  8. Notice that a new file has been created. It has been named as “Connection name” that we had input earlier. Viewing this file in Dreamweaver shows the PHP contents that is responsible for connecting to MYSQL.

There you go, with this setup, Dreamweaver is already connected to your MYSQL database

One of the advantages coding with Dreamweaver is that it's able to fetch the MYSQL table names, so when you're in the process of creating your sql statements, Dreamweaver can help with the autocomplete of database tables/field names.

Goodluck on this feel free to post back if you have questions

Reply With Quote
  #3 (permalink)  
Old 07-29-2011, 11:42 AM
blueplanet blueplanet is offline
Junior Member
Join Date: Mar 2006
Posts: 6
blueplanet is on a distinguished road


Thank you for your detailed reply. It is very informative but i have to work on sql server 2005 not in mysql. I have windows 7 ultimate. and i have installed visual studio 2005 in which sql server 2005 is already there. The website in which i am working on is static. Its in dreamweaver. Now i want to add a page of database which will be in sql server 2005 and then want to connect it to dreamweaver.
The problem is now, somebody has made a database and given me a folder which has one file of Ms Acess, two files of dreamweaver, a file of type XML configuration type and two other files of type ".aspx.vb" I dont know how to put this files on sql server 2005, how to run them.and finally connect it with dreamweaver.
Could you please guide me.
Thanks for your consideration and time
God bless you

Reply With Quote
  #4 (permalink)  
Old 07-29-2011, 02:46 PM
DominicD DominicD is offline
Senior Member
Join Date: Feb 2011
Posts: 251
DominicD is on a distinguished road


Hello blueplanet,

Glad that you found the previous post to be helpful.

I don’t have first hand experience using MS SQL Server 2005, but below is a link to what I found on the net..

A blog post from here tells the author’s experience with exporting an access file to the sql server 2005 database.

You can read his experiences and observations on his post.. and then near the end of his post, he explains using a tool called “Microsoft Microsoft SQL Server Migration Assistant for Access v5.1

He provided a link to a word document that details the step-by-step instructions.

Here is a link to the Word document direct from his blog

In case the link does not work, I reuploaded the word document a MediaFire


Note that from the Word document, he cited some software requirements before the installation of Microsoft Microsoft SQL Server Migration Assistant for Access. I’ve read through the word document, and below are the latest and updated links for downloading the prerequisite software..


Microsoft .NET Framework Version 2.0 Redistributable Package (x86)


Microsoft Visual J# Version 2.0 Redistributable Package


Microsoft SQL Server Migration Assistant for Access v5.1


Goodluck on this

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are on

» Ads

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54