MySQL and .asp

[Guest]

I'm creating an asp data base site on a mac and have a connected PC for use as a testing server. I plan to use MySQL for the data base but all the books I have been following refer to MySQL in conjunction PHP not .asp. Are there any complications using .asp and MySQL together, and secondly what do I need to do within Dreamweaver to link to the testing server and to the data base. This is all new to me, the PC's IIS and the MySQL data base feel like 2 independent elements I'm not completely clear on how these should work together.
Any help appreciated.

[matthew stuart]

None what-so-ever. It is effectively the same as using Microsoft Access apart from the fact that it is lacking in a GUI like access. However, if you have it running on a PC, you can download something like Heidi SQL which if memory serves me correct is free. This then basically gives you your GUI. This means that you can visually build the db and its tables rather than hand code it.

The Mac has the ability to create php in dreamweaver and serve the php pages with its built in apache server, so that might be something to consider as you are already on a Mac. I use ASP because I learnt this stuff years ago and have never really had the time of bravery to go through the same pain as I went through many years back!

Have you run MySQL on a Mac yet, and if so, have you found a GUI for it that works on a Mac?

Mat

[matthew stuart]

Forgot to say, if you're connecting via OLEDB, then you can download 'myOLEDB'.

[Guest]

My ISP prefers asp, hence the network PC testing server, so I intend to use PHPmyadmin to create the tables on the PC, and then .asp web forms to maintain them. I have trawled the web for a Mac MySQL GUI but found nothing.
Thanks for the help
Rob

[Newsgroup_User]

R.S.Design wrote:
> I have trawled the web for a Mac MySQL GUI but found nothing.

Why not go straight to the source?

http://dev.mysql.com/downloads/gui-tools/5.0.html

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