Database Access with Dreamweaver

[LaFonda Robbins]

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

[Edi8th99]

Re: Database Access with Dreamweaver

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

[jackleinjil]

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.

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

[horace11091]

Re: Database Access with Dreamweaver

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

[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 ?

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

[jandrenievs]

Re: Database Access with Dreamweaver

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

[josephwilson]

Re: Database Access with Dreamweaver

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

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

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

[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

[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,

[nuorderwebs]

Re: Database Access with Dreamweaver

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