Database Access with Dreamweaver

[swanside Junior Member Find all posts View Profile Close swanside]

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.

[John_Accuwebhosting Senior Member Find all posts View Profile Close John_Accuwebhosting]

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!

[Web Hosting Review Junior Member Find all posts View Profile Close Web Hosting Review]

Re: Database Access with Dreamweaver

Is possible to conncet Dreamweaver with sql or access ?

[nuorderwebs Junior Member Find all posts View Profile Close nuorderwebs]

Re: Database Access with Dreamweaver

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

[kilter Member Find all posts View Profile Close kilter]

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,

[d2hsean Junior Member Find all posts View Profile Close d2hsean]

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

[Mark Joshi Junior Member Find all posts View Profile Close Mark Joshi]

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

[Mark Joshi2 Junior Member Find all posts View Profile Close Mark Joshi2]

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.

[Mark Peter Junior Member Find all posts View Profile Close Mark Peter]

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

[josephwilson Junior Member Find all posts View Profile Close josephwilson]

Re: Database Access with Dreamweaver

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

[jandrenievs Junior Member Find all posts View Profile Close jandrenievs]

Re: Database Access with Dreamweaver

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

[regeret Junior Member Find all posts View Profile Close regeret]

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.

[Crish Bronzs Member Find all posts View Profile Close Crish Bronzs]

Re: Database Access with Dreamweaver

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

[horace11091 Junior Member Find all posts View Profile Close horace11091]

Re: Database Access with Dreamweaver

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

[campnbell Junior Member Find all posts View Profile Close campnbell]

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.