| 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: 15 February 2003 at 11:12am |
|
The forum won't run at all with PHP, that would require a complete re-write of all the code in the forum, and not just some of the SQL queries.
|
|
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 February 2003 at 12:56pm |
I have been working on a mySQL version and so far probally spent around 6 hours and still not got anywhere with it.
There are quite a few problems, including, changing field names as mySQL doesn't like many feild names, mySQL doesn't have a true/false or bit datatype, can't create relationships between tables, these are just a few of the problems I have incounted so far and thats before starting on changing any of the SQL queries, as version 7 includes things like sub quiries which are not supported by mySQL and also stored procedures are also not supported.
|
|
|
|
turdfurgeson
Newbie
Joined: 25 September 2002
Location: United States
Status: Offline
Points: 29
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 February 2003 at 2:23pm |
Just a random FYI.
MySQL 5 (which isn't out yet) will be able to handle stored procs and triggers.
|
|
dolby71
Senior Member
Joined: 27 October 2002
Location: Israel
Status: Offline
Points: 203
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 February 2003 at 2:50pm |
But still MySQL isn't as good as MSSQL, The problem is, that i can't work with access db's since it's very slow, and now i gotta find a new host, which will be affordable, fast,and with SQL 2000 support...
I can't find one which is inexpensive.... 
|
|
Bunce
Senior Member
Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 February 2003 at 5:15pm |
|
You get what you pay for.
|
|
There have been many, many posts made throughout the world...
This was one of them.
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 February 2003 at 5:31pm |
|
I think $10 a month for a host with SQL2000 is not bad. You will find a few of those. You say MySQL isn't as good as MSSQL well that all depends on the application. If an app is designed to run on MySQL it actually runs faster then on MSSQL, for low to medium apps that is. Of course if you have someone pounding the database then something like MSSQL is more robust but who actually does that. Also you say that the problem is that it can't work with Access. What do you mean by that. You can import Access tables fairly easy, there are tools on CNet to download.
|
|
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 7:35am |
I found another big problem with converting the forum to use mySQL, it seems that the mySQL/ODBC driver has big problems with ADO updates, instead you have to use SQL insert statement then execute it.
99% of the data in the forum is infact using ADO to update the database, this would mean that all these would have to be changed to make the forum compatible with mySQL.
|
|
|
|
dolby71
Senior Member
Joined: 27 October 2002
Location: Israel
Status: Offline
Points: 203
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 February 2003 at 7:58am |
 -boRg- wrote:
I found another big problem with converting the forum to use mySQL, it seems that the mySQL/ODBC driver has big problems with ADO updates, instead you have to use SQL insert statement then execute it.
99% of the data in the forum is infact using ADO to update the database, this would mean that all these would have to be changed to make the forum compatible with mySQL.
|
Yeah, i also met this problem in the past...
You DO have to use SQL now, This sucks..
If you want, please contact me and i'll help you with the ADO -> SQL converting...
Please PM me if you wantme to...
|
|
