Blog Documentation Book a Demo
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Using MSAccess instead of mySQL

trooperbilltrooperbill
edited July 2007 in Vanilla 1.0 Help
i know that mySQL is free and open source yet my host seems to want to charge me for the privilage whereas i can use as many MSAccess databases as i like so my question is this. How do i modify the forum script to support MSAccess instead of mySQL and what fields need to be set up. many thanks mark www.neue.co.uk

Comments

  • MinisweeperMinisweeper New
    How confident are you with php and MSAccess? It wont be a small job by any means...
  • WallPhoneWallPhone
    That would be quite a project. I wouldn't recommend it unless you already know your way around PHP, MySQL and SqlServer. It might be easier to switch hosts or find a dedicated MySQL host.

    First suggestion is to look at the PostgreSQL patch, compare it to the existing Vanilla files and that will give you an idea of what needs to be changed.

    Next, you may want to turn on 'can view debug info' role permission for your testing accounts, and then go to example.com/vanilla/debug.php to switch on the debug mode, which will allow you to see all the SQL statements that get sent to the database.

    And finally, you should override the Framework.Class.SqlBuilder.php class to change syntax differences such as date formats and using TOP instead of LIMIT.


    (Speaking of which--shouldn't the MysqlDateTime() function be changed to a method of the MySQL class since it returns a mysql-specific date format--i.e. change calls to $Context->Database->DateTime()?)
  • trooperbilltrooperbill
    im not a PHP guy... dabble in asp, but thats all (hence my preference for MS Access)
This discussion has been closed.