Database Access with Dreamweaver

Collapse

Unconfigured Ad Widget

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 2
  • Filter
  • Time
  • Show
Clear All
new posts
Previous 1 2 template Next
  • swanside
    Junior Member
    • Oct 2007
    • 1
    #1

    Database Access with Dreamweaver

    Hi, I am trying to setup a couple of web pages to access a database which I have uploaded to my web space. I have created a MySQL Database called test.
    Now, I am using dreamweaver and although I can set up the site to access accuwebs servers when I try to make a database connection I get HTTP Eror Code 400 Bad Request, errors.

    Tags: None
  • John_Accuwebhosting
    Senior Member
    • Jun 2006
    • 120
    #2
    Re: Database Access with Dreamweaver

    Hello,

    It seems that you are using incorrect connectionstring to connect with your MySQL database. Please visit the below mentioned URL to get different examples of MySQL database connectionstrings:

    ConnectionStrings.com - How to connect to MySQL

    Cheers!
    Last edited by Marc_AccuWebHosting; 11-15-2019, 09:09 AM.
    John D.
    Support Technician,
    accuwebhosting.com
    Windows based hosting
    Linux based hosting

    Comment

    • Web Hosting Review
      Junior Member
      • Dec 2007
      • 1
      #3
      Re: Database Access with Dreamweaver

      Is possible to conncet Dreamweaver with sql or access ?

      Comment

      • nuorderwebs
        Junior Member
        • Apr 2008
        • 1
        #4
        Re: Database Access with Dreamweaver

        why not just use MYSQL query browser, Dreamweaver is notoriously buggy and cumbersome for these things

        Comment

        • kilter
          Member
          • Oct 2009
          • 79
          #5
          Re: Database Access with Dreamweaver

          I have just successfully done this today using dreamweaver 8

          When creating a database link in dreamweaver make sure that the testing server has a host directory of /web or you will get errors as dreamweaver tries to create (and gets denied) files in the wrong folder.

          My Server connection (from within the dreamweaver panel) are as follows:

          SQLServer: Localhost
          Username: web1_u1
          Password: *******
          Database: web1_db1

          You can find out your MySQL details in ISPConfig under ISPManager, <Select your site>, Options TAB and your databases and users will be listed there. If not click the new button and create one.

          Edit: The testing server should be setup to FTP into your webserver using normal FTP login details.

          Hope that helps,

          Comment

          • d2hsean
            Junior Member
            • Jan 2010
            • 10
            #6
            Re: Database Access with Dreamweaver

            Hi,

            Always use your host name as localhost and then try to access the database using the db name, password, and db user details.

            It works

            Comment

            • Mark Joshi
              Junior Member
              • Sep 2010
              • 1
              #7
              Re: Database Access with Dreamweaver

              you should look into MySQL, as Access is a bit harder to use / set up on a webhost, and with languages php its easier with MySqL. If you go with ASP, then thats another story and I dont much about it

              Comment

              • Mark Joshi2
                Junior Member
                • Oct 2010
                • 1
                #8
                Re: Database Access with Dreamweaver

                When creating a database link in dreamweaver make sure that the testing server has a host directory of /web or you will get errors as dreamweaver tries to create (and gets denied) files in the wrong folder.

                Comment

                • Mark Peter
                  Junior Member
                  • Oct 2010
                  • 3
                  #9
                  Re: Database Access with Dreamweaver

                  USING "MySQL Database" option you can create mysql databsae. After creating mysql database you've to add users to that mysql database. You can do that in the same screen of "MySQL Database".

                  Comment

                  • josephwilson
                    Junior Member
                    • Nov 2010
                    • 1
                    #10
                    Re: Database Access with Dreamweaver

                    yeah u have to create mysql database to over come on the problem.

                    Comment

                    • jandrenievs
                      Junior Member
                      • Dec 2010
                      • 1
                      #11
                      Re: Database Access with Dreamweaver

                      there are many complaints about the dreamweaver, better not use it..

                      Comment

                      • regeret
                        Junior Member
                        • Dec 2010
                        • 1
                        #12
                        Re: Database Access with Dreamweaver

                        When creating a database link in dreamweaver make sure that the testing server has a host directory of /web or you will get errors as dreamweaver tries to create (and gets denied) files in the wrong folder.

                        Comment

                        • Crish Bronzs
                          Member
                          • Jan 2011
                          • 40
                          #13
                          Re: Database Access with Dreamweaver

                          Yes, MySQL will be easy to use with Dream-viewer. Can you which server you are going to use ?

                          Comment

                          • horace11091
                            Junior Member
                            • Jul 2011
                            • 3
                            #14
                            Re: Database Access with Dreamweaver

                            why not just use MYSQL query browser, Dreamweaver is notoriously buggy and cumbersome for these things!

                            Comment

                            • campnbell
                              Junior Member
                              • Sep 2011
                              • 5
                              #15
                              Re: Database Access with Dreamweaver

                              When creating a database link in Dreamweaver to ensure that the test server has a host directory / web, or you will get errors that Dreamweaver is trying to create files in the wrong folder.

                              Comment

                              Previous 1 2 template Next
                              Working...
                              X