How do you integrate a data base with a web site?

Report · Nov 02, 2006

I've been designing sites for a few years but have no knowledge of how to integrate a data base (Miscrosoft Access) that already exist into a web site I have been asked to design.

So I have 3 questions:

1. How difficult is it to learn how to do this myself
2. What should I charge the company who is asking me to do the work.
3. Can anyone recommend a possible partnership for me to get my bid submitted and have the confidence to know the work will get done.

Am I even asking the right questions?

Thanks in advance for your advice.

David

Report · Nov 05, 2006

David

It is not that difficult to do, and DW can provide about 90% of the coding
for you using the server behaviours. The tricky bits are getting the
database design right. However this is all dependent on what the client
wants.

In terms of how much to charge you need to be mindfull that you are a novice
and therefore will take longer and therefore have to discount the hours
taken.

In terms of help there is plenty of free support here. If you need someone
to look at the specs and let you know how difficult it will be send me an
email offline.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"covenant2" <webforumsuser@macromedia.com> wrote in message
news:eid0ql$qhr$1@forums.macromedia.com...
> I've been designing sites for a few years but have no knowledge of how to
> integrate a data base (Miscrosoft Access) that already exist into a web
> site I
> have been asked to design.
>
> So I have 3 questions:
>
> 1. How difficult is it to learn how to do this myself
> 2. What should I charge the company who is asking me to do the work.
> 3. Can anyone recommend a possible partnership for me to get my bid
> submitted
> and have the confidence to know the work will get done.
>
> Am I even asking the right questions?
>
> Thanks in advance for your advice.
>
> David
>
>

Report · Nov 06, 2006

Hello Paul,
Thanks so much for getting back to me on this. I eventually did find someone to do the work that is very knowledgeable. I got some pricing from him as well and he lives just a few miles from here.

I get offered these DB RFPs often and am always at a loss as to how to proceed. I’m not in a position to turn down money so I need to take the time to learn how to do the work myself.

I think I have all my bases covered after talking to my DBA guy but if I do require additional help I would like to consider you as a resource.

Thanks again.

David

Report · Nov 11, 2007

I'm building a dynamic site using DW MX 04. The Data base is built and connected to DW but I keep getting the follwing error on line 2. Need some help figuring this out. All things being equal should this not work?

Server Error in '/' Application.
--------------------------------------------------------------------------------

Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: ?

Source Error:

Line 1: <%@ Page Language="C#" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
Line 2: <%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
Line 3: <MM:DataSet
Line 4: id="DataSet1"

Source File: \\zelda\vhosts$\cookmanneighborh\public_html\test.aspx Line: 2

Assembly Load Trace: The following information can be helpful to determine why the assembly 'DreamweaverCtrls' could not be loaded.

=== Pre-bind state information ===
LOG: DisplayName = DreamweaverCtrls, Version=1.0.0.0, Culture=neutral, PublicKeyToken=836f606ede05d46a
(Fully-specified)
LOG: Appbase = file://zelda/vhosts$/cookmanneighborh/public_html
LOG: Initial PrivatePath = bin
Calling assembly : (Unknown).
===

LOG: Publisher policy file is not found.
LOG: No redirect found in host configuration file (c:\windows\microsoft.net\framework\v1.1.4322\aspnet.config).
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\config\machine.config.
LOG: Post-policy reference: DreamweaverCtrls, Version=1.0.0.0, Culture=neutral, PublicKeyToken=836f606ede05d46a
LOG: Attempting download of new URL file:///c:/windows/microsoft.net/framework/v1.1.4322/Temporary ASP.NET Files/root/81f47a49/40869791/DreamweaverCtrls.DLL.
LOG: Attempting download of new URL file:///c:/windows/microsoft.net/framework/v1.1.4322/Temporary ASP.NET Files/root/81f47a49/40869791/DreamweaverCtrls/DreamweaverCtrls.DLL.
LOG: Attempting download of new URL file://zelda/vhosts$/cookmanneighborh/public_html/bin/DreamweaverCtrls.DLL.
LOG: Attempting download of new URL file://zelda/vhosts$/cookmanneighborh/public_html/bin/DreamweaverCtrls/DreamweaverCtrls.DLL.
LOG: Attempting download of new URL file:///c:/windows/microsoft.net/framework/v1.1.4322/Temporary ASP.NET Files/root/81f47a49/40869791/DreamweaverCtrls.EXE.
LOG: Attempting download of new URL file:///c:/windows/microsoft.net/framework/v1.1.4322/Temporary ASP.NET Files/root/81f47a49/40869791/DreamweaverCtrls/DreamweaverCtrls.EXE.
LOG: Attempting download of new URL file://zelda/vhosts$/cookmanneighborh/public_html/bin/DreamweaverCtrls.EXE.
LOG: Attempting download of new URL file://zelda/vhosts$/cookmanneighborh/public_html/bin/DreamweaverCtrls/DreamweaverCtrls.EXE.

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300

Report · Nov 13, 2007

> I'm building a dynamic site using DW MX 04. The Data base is built and
> connected to DW but I keep getting the follwing error on line 2. Need some
> help
> figuring this out. All things being equal should this not work?

It appears that your server can't find the Adobe DLL files.

FYI, ASP.net really shouldn't be built within DW. Use Visual Studio for
that.

-Darrel

Report · Nov 13, 2007

Darrel,
Thanks for getting back to me. I figured it out lt last night. I put the DreamweaverCtrl.dll on the server in the bin folder and submitted the web.config file and it worked fine. Took me all day and several tutorials to figure it out but it works now.

Thanks
David

Report · Nov 18, 2007

Is there a script that is available to use for onclick button to login administrators for a data base? Or is there a better way to do it in DW MX 04? I can't seem to find it in the data base applications panel.

David