General Discussion

Print Page | Close Window

mySQL

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=2581
Printed Date: 29 March 2026 at 10:25am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: mySQL

Posted By: Gullanian
Subject: mySQL
Date Posted: 10 May 2003 at 10:59am

What changes need to be made to the forum to adapt it for a mySQL database, and if it takes too long to explain is there any site out there with a tutorial or description on script differences?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 10 May 2003 at 12:31pm

It would mean re-writting every page, as the myODBC database drivers don't fully support ADO so all ADO inserts and updates would have to be changed and written as SQL Update statements etc. which will also mean cerating new security filters and adding extra protection to stop things like SQL injections.

Also mySQL is not a relational database so you would have to cerate the foum databases without the relations.

Many of the SQL statements may also have to be changed as things like Top 1 and sub quiries are not supported.

In other words the forum would need to be totally re-written to use mySQL.

I myself am going to stay away from mySQL until it has more features and they improve the myODBC driver so that ASP/ADO can talk to a mySQL database faster and with more functionality.

-------------
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: Gullanian
Date Posted: 10 May 2003 at 1:10pm

Any other database drivers I can use with mySQL which will support it without need to re-write anything or much? Even if they cost money?

And also what other databases, apart from SQL, are there out there?

Posted By: michael
Date Posted: 10 May 2003 at 2:04pm

Sybase, Pervasive SQL, DB2 and on and on, there are tons but the problem is that there are not a lot of hosts who would have them. I dont think that there are other mysql drivers that you could use...

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker