Announcement

Collapse
No announcement yet.

Database Access with Dreamweaver

Collapse

Ads on showthread pages

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Access with Dreamweaver

    WordPress Hosting on SSD Servers
    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.


  • #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!

    Comment


    • #3
      Re: Database Access with Dreamweaver

      Is possible to conncet Dreamweaver with sql or access ?

      Comment


      • #4
        Re: Database Access with Dreamweaver

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

        Comment


        • #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


          • #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


            • #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


              • #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


                • #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


                  • #10
                    Re: Database Access with Dreamweaver

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

                    Comment


                    • #11
                      Re: Database Access with Dreamweaver

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

                      Comment


                      • #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


                        • #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


                          • #14
                            Re: Database Access with Dreamweaver

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

                            Comment


                            • #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


                              • #16
                                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.
                                Last edited by jackleinjil; 09-24-2011, 01:23 PM.

                                Comment


                                • #17
                                  Re: Database Access with Dreamweaver

                                  why not just use MYSQL query browser, Dreamweaver is notoriously buggy and cumbersome for these things.
                                  Last edited by Marc_AccuWebHosting; 05-14-2016, 04:39 AM.

                                  Comment


                                  • #18
                                    ASP.Net Hosting starts @ $3.18/Mo.
                                    Re: Database Access with Dreamweaver

                                    Your database is on the server so you'll need a script to interact with the server, familiar name: server-side script, such as ASP or PHP and in this case you'll likely need ASP. And this is how to connect to MSAccess.

                                    ◘ Connect to a MS Access database using a DSN.
                                    ================ ====================== ==========
                                    Set oConn = Server.CreateObject("ADODB.Connection")
                                    oConn.Open "DSN=;UID=;PWD="
                                    oConn.Close

                                    ◘ Connect to a MS Access Database using DSN less OLEDB connection.
                                    ================= ================== ==============
                                    Set oConn = Server.CreateObject("ADODB.Connection")
                                    oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("") & ";" oConn.Close
                                    Set oConn = Nothing

                                    ◘ Connect to a MS Access database using DSN less ODBC connection.
                                    ===================== ================== =========
                                    Set oConn = Server.CreateObject("ADODB.Connection")
                                    oConn.Open "DRIVER={Microsoft Access Driver(*.mdb)};DBQ=" & Server.MapPath("") & ";UID=;PWD="
                                    oConn.Close
                                    Set oConn = Nothing

                                    note: Server.MapPath("") is your virtual path.

                                    Other useful links
                                    =============

                                    Comment

                                    Working...
                                    X
                                    Sign up for a News Letter Click here to sign up