MySQL

[VagJim22]

I am trying to build a dynamic website using MS Access.
My q is if it is necessary to download MySQL to create databases and recordsets.
I am having some connection-related problems and i am just wandering if the absence of MySQL has a role in it.

[Newsgroup_User]

VagJim22 wrote:
> I am trying to build a dynamic website using MS Access.
> My q is if it is necessary to download MySQL to create databases and
> recordsets.
> I am having some connection-related problems and i am just wandering if the
> absence of MySQL has a role in it.
>

MS Access is very different to MySQL, the lack of one will not effect
the other.

Steve

[MikeL7]

I would look into using MSSQL Server 2005 Express edition, it free and is much better that access, you can install it on a XP Pro machine and develop databases using the SSMS. A really good database for free, if your using PHP then use MySQL.
Connecting to either one is simple if they are installed proplery, look at a few Tutorials - Google Install MSSQL server 2005 express or MySQL.

[VagJim22]

This site i am constructing is only for testing purposes and it is local(meaning that it resides on my PC and not in a remote server).
So, for testing purposes what do you believe is better MySQL or Access?

[Newsgroup_User]

VagJim22 wrote:
> So, for testing purposes what do you believe is better MySQL or Access?

It depends which server technology you plan to use. For PHP, you need
MySQL to develop a database-driven site with Dreamweaver. For ASP or
ColdFusion, either is OK, although Access is probably better with ASP.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[edglenning]

If this is all local what is your connection related problem? I am confused if it is all on the same host the connection problem may be driven by a configuration issue. I use PHP, Apache and MySQL for my local host and it works awesome. The apps really don't impact my local PC's perfromance at all either.

[VagJim22]

Hi i am going to be more specific about the connection-related problem i am facing.
The problem appears when i go to create a recordset at an ASP page and all these after the successful completion
of a database.
In the RS creation process i press the TEST button and the table appears meaning so far no problem.
The trouble begins when i go to save the created RS. I get a save as dialog box(and i cannot understand why) and a 2nd page is created which is connected with 1st and if i go to delete it a message appears warning me that the connection will be lost and if i do that the familiar red exclamation mark appears in the server behaviors panel.
My q is why a second page is created. Why the DB and the RS cannot co-exist in the sane page and DW creates a second.
If you want i can give you more details regarding the problem but for start let's see what we can do with above facts
Can you make any SENSE out of these?
So stating it again WHY A 2ND PAGE IS CREATED?

[Newsgroup_User]

VagJim22 wrote:
> Hi i am going to be more specific about the connection-related problem i am
> facing.
> The problem appears when i go to create a recordset at an ASP page and all
> these after the successful completion
> of a database.
> In the RS creation process i press the TEST button and the table appears
> meaning so far no problem.
> The trouble begins when i go to save the created RS. I get a save as dialog
> box(and i cannot understand why) and a 2nd page is created which is connected
> with 1st and if i go to delete it a message appears warning me that the
> connection will be lost and if i do that the familiar red exclamation mark
> appears in the server behaviors panel.
> My q is why a second page is created. Why the DB and the RS cannot co-exist in
> the sane page and DW creates a second.
> If you want i can give you more details regarding the problem but for start
> let's see what we can do with above facts
> Can you make any SENSE out of these?
> So stating it again WHY A 2ND PAGE IS CREATED?
>

What is the second page called?

Steve