SysChat

SysChat (http://www.syschat.com/forum.php)
-   Operating Systems (http://www.syschat.com/software-support/operating-systems/)
-   -   plz reply its urgent!windows7,sql server and dreamweaver (http://www.syschat.com/plz-reply-its-urgent-windows7-sql-6896.html)

blueplanet 07-28-2011 04:57 AM

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

DominicD 07-28-2011 02:12 PM

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..

SQL –
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.

http://i56.tinypic.com/2rpv585.jpg
Download XAMPP here: http://www.apachefriends.org/en/xampp-windows.html

When you have XAMPP installed and running, you should see the XAMMP control panel similar to the one below..
http://i53.tinypic.com/2wf8vuo.jpg

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
    http://i56.tinypic.com/21yl1e.jpg

  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
    http://i54.tinypic.com/ofq6th.jpg

  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.
    http://i56.tinypic.com/30vj285.jpg
    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.
    http://i51.tinypic.com/mk93bk.jpg

  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.
    http://i51.tinypic.com/wttwg4.jpg

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 :)

blueplanet 07-29-2011 11:42 AM

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

DominicD 07-29-2011 02:46 PM

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 http://cfpayne.wordpress.com/2006/07...l-server-2005/ 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
http://cfpayne.files.wordpress.com/2...erver_2005.doc

In case the link does not work, I reuploaded the word document a MediaFire
http://www.mediafire.com/?eaeda4mquzqpc1h

=====================

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)

http://www.microsoft.com/download/en/details.aspx?id=19


=======

Microsoft Visual J# Version 2.0 Redistributable Package
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=4712

=======

Microsoft SQL Server Migration Assistant for Access v5.1
http://www.microsoft.com/download/en/details.aspx?id=26709



==========

Goodluck on this :)


All times are GMT -4. The time now is 07:20 AM.


Copyright © 2005-2013 SysChat.com


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