Solved

MySQL and ASP support in MX 2004

Posted on 2003-11-08
5
273 Views
Last Modified: 2010-04-25
Hi all,

A quick question I hope you can help with....... I am used to using Dreamweaver (ASP) with Access and MsSQL Databases, however i have been given a MySQL DB to connect to.

Firstly, can I use it with my ASP pages? If so, how...

I can connect to the DB fine using a dsn or a custom string, the connection test is fine,  however according to Dreamweaver there are no tables in the DB?!

Do I need an extension to support ASP and MySQL perhaps??

Any advice gratefully recieved.
0
Comment
Question by:SteveTr
  • 2
  • 2
5 Comments
 
LVL 23

Expert Comment

by:adilkhan
ID: 9708353
0
 
LVL 8

Expert Comment

by:klykken
ID: 9708646
0
 

Author Comment

by:SteveTr
ID: 9709406
Cheers for the answers guys,

I can connect to the database OK....

I take it then, that if I have a MySql DB that my pages have to be written in PHP when using Dreamweaver? I know that ASP can talk to MySql ok, Is there not an extension available for Dreamweaver or something that I can use to support ASP and MySQL?

Cheers
0
 
LVL 8

Accepted Solution

by:
klykken earned 200 total points
ID: 9711174
Hmm.. I have never used ASP and MySQL in combination, but I think I've fuond something to help you out. It seems Macromedia has a dev center specifically for asp(.net). Look at it, it might have what you need.
http://www.macromedia.com/devnet/dotnet/

-klykken
0
 

Author Comment

by:SteveTr
ID: 9711264
Thanks klykken, you are right.... from reading that site it seems native asp and MySql support doesnt exist, but when using .net this issue is overcome... i've tested using .net and can see the tables, query the DB and receive results etc. etc... thanks for your help again...
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now