|
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 |
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:
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:
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 :) |
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 |
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 09:44 AM. |
Copyright © 2005-2013 SysChat.com