Forum Moderators: open

Message Too Old, No Replies

ASP and MySQL, is this a good idea?

Looking for suggetions....

         

dataguy

11:28 pm on Dec 18, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I've run into some situations with SQL Server where it seems that MySQL would do better (mostly with full-text queries). I've never worked with MySQL, but I've heard that it can be connect to through ODBC. Is this an OK idea? Can it be managed through Enterprise Manager or something similar? Does anyone have any advice to offer? Thanks!

mattglet

3:05 pm on Dec 19, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



mySQL works just fine with ASP. You connect to the database via the mySQL ODBC driver, which most hosts should provide.

As far as management, you cannot use Enterprise Manager. EM is only for MSSQL databases; you must use mySQL specific management tools. One tool I have used in the past is phpmyAdmin.