| Author |
 Topic Search  Topic Options
|
WebWiz-Bruce 
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 16 February 2003 at 8:02am |
|
Thanks, it should be OK, just a shame to loose the extra security and functionality of using ADO updates.
|
|
|
 |
dolby71
Senior Member
Joined: 27 October 2002
Location: Israel
Status: Offline
Points: 203
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 February 2003 at 8:05am |
|
So your'e saying that the SQL is less secured than ADO? But what's the difference? i mean, i know the difference, but how is it working differently?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 February 2003 at 3:50pm |
When using ADO it's much more difficult to use malcious code with SQL injections, also ADO can handle single quote marks ' which when using SQL would have to be turned into two quote marks to escape, otherwise the SQL statement would crash.
I think mySQL will have to be forgotten about at the moment, as to make the forum compatible almost every page needs to be re-written, not just ADO updates, but also mySQL can't handle sub quiries, theres no bit or true/false datatype, you can't create raltionships between tables, you can't use TOP # to limit the number or returned records, no record paging, and these are just a few of the problems I have encountered so far.
|
|
|
|
turdfurgeson
Newbie
Joined: 25 September 2002
Location: United States
Status: Offline
Points: 29
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 February 2003 at 12:37am |
Just another simple look on this would be: This forum is using ASP, which obviously runs on IIS only (ChiliSoft ASP is a pointless nightmare so don't bring that one up...  ). So it would make perfect since to keep it a MSSQL site or access. If it were written in PHP or perl or something to that nature, it would make sense to write it for MySQL. Probably most of the people who download and use this forum are not going to have a need for a MySQL version. Just the few people who have the MS/Linux mix setup could see a need for this. Just my thoughts.
|
|
djscout
Senior Member
Joined: 16 February 2002
Location: United States
Status: Offline
Points: 242
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 February 2003 at 5:27am |
|
i agree with turdfurgeson. borg has the right frame of mind keeping it for Access and SQL Server. those are the two most important in my book anyways. mySql is great but i honestly dont think its necessary if a sqlServer version already exists! With the faster processing, stored procedures and other better features offered, it just makes sense.
|
|
++ jim..
|
|
trendecide
Groupie
Joined: 26 May 2002
Location: United States
Status: Offline
Points: 54
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 February 2003 at 10:44am |
You'd think after this HUGE argument someone would mention DSN. If you can use DSN for Access, you can use it for mySQL. Use an Access to SQL converter to dump the table structure and setup myODBC. Admittedly DSN is slower than a direct connect, but at least you can use mySQL.
This is an ASP board though... using mySQL goes beyond me. if you need mySQL, go use PHP (which sucks by the way). I've some to dislike mySQL after years of use...
|
|
Love, Peace and Chicken Grease!
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 February 2003 at 11:40am |
I have already written a script that will create the database tables and structure on mySQL, but it's not as simple as that as many, many pages would have to be re-written.
If a mySQL server version is made it might have to be a compltly different code base as it would be a shame to lose performance and security in other versions just to accomodate mySQL.
|
|
|
|
Bunce
Senior Member
Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 February 2003 at 4:10pm |
Wait a bit for a newer version of MySQL Borg. I'm getting back into at work shortly so will have a stab at converting the SQL with you if you like Bruce. The Sub-Queries are gonna be the killer!
I wish everyone would stop this ASP-SQL Server versus PHP-MySQL cr*p. One is a web server, the othe other is a database. The aim of web applications should be a multi-tier approach which attempts to keep each tier independant of the other.
Yes, there are issues with the data layer between these two data sources, however it doesn't meet it shouldn't be attempted. And especially not because of some religion which says PHP should go with MySQL or ASP should go with SQL Server.
Again, Bruce if you would like some help with the SQL conversion let me know. I've got to study for my MCDBA exam the next few weeks but after that I'm free.
Cheers,
Andrew
|
|
There have been many, many posts made throughout the world...
This was one of them.
|
|
