Web Wiz Forums - WebWiz i MySQL4

Print Page | Close Window

WebWiz i MySQL4

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=1401
Printed Date: 03 April 2026 at 10:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: WebWiz i MySQL4

Posted By: MariuszM
Subject: WebWiz i MySQL4
Date Posted: 27 March 2003 at 7:38am

I heard that MySQL version 4 ( http://www.mysql.com/press/release_2003_10.html - Press ) supports subqueries. If that's true, there will be WebWiz forum for MySQL?

-------------
regards, MariuszM

Replies:

Posted By: WebWiz-Bruce
Date Posted: 27 March 2003 at 7:49am

No as it's more than just the sub quiries that are the problem, ASP doesn't talk to an mySQL database very well using ODBC as the myODBC drivers is not very good and so you loose quite a number of features.

To make the forum work with mySQL would require that 99% of the pages to be re-written, loosing performance and security from the forum, so I would rather concetrate on Access and SQL server which are used more often with ASP.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: hans3702
Date Posted: 15 April 2003 at 1:29pm

What I found........
I'am not in SQL yet but this sound good.

Hans

==================================================
Using the Easysoft SQL Engine
( http://www.easysoft.com/products/sql_engine/main.phtml - http://www.easysoft.com/products/sql_engine/main.phtml ) you could do both!

Use Access for now with ODBC, then when you want to move to MYSQL, SQL Server or any ODBC Data source, just change the data source and your code will work without modification (so long as the tables have the same structure). It will even iron out a few of the "irregularities" in MYSQL too

You can download a FREE personal edition from the website
===================================================

Edit: no free personal edition anymore? price

-------------

Posted By: The WizeGuy
Date Posted: 02 October 2003 at 5:33am

-boRg- wrote:

No as it's more than just the sub quiries that are the problem, ASP doesn't talk to an mySQL database very well using ODBC as the myODBC drivers is not very good and so you loose quite a number of features.

I use MySQL with both Classic ASP and ASP.NET daily as a proffessional WebDeveloper, so that is BULL.

-boRg- wrote:

To make the forum work with mySQL would require that 99% of the pages to be re-written, loosing performance and security from the forum, so I would rather concetrate on Access and SQL server which are used more often with ASP.

In my opinion, Recordset.AddNew, should almost NEVER been used due to negative performence issues (more overhead with .AddNew than with regular INSERT, UPDATE and DELETE in straight SQL-queris)

Security? what are You talking about ..... You have more security with a MySQL database than an Access ....

IF! you had avoid that in code (.AddNew), the conversion to mySQL should be as easy as add another if-statement to runt against mySQL instead of MS-SQL or Access and some queries where dates are involved.

just my �0.02

/PatrikB

Posted By: WebWiz-Bruce
Date Posted: 02 October 2003 at 5:51am

To your first point, the myODBC driver doesn't fully support ADO this is where the problem lies.

To your secound point, using SQL to update, delete, etc. is less secure as it is more open to SQL injections, this is where the security problems I mention lie.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting