Search code examples
mysqlsql-server

How do I connect Biostar V1.8 Suprema to MySQL?

I'm installing Biostar Suprema apps V1.8. Currently the default DB is using MSSQL.
How can I change the DB from MSSQL to MySQL?

Solution

  • This is the steps:

    1. Install MySQL DB and Run MySQL DB service.

    2. Install mysql-connector-odbc-5.1.10-win32.msi <-- must use this version of odbc

    3. Stop the Biostar Server Service at services.msc

    4. Stop MSSQL Service

    5. Next, Go to folder --> C:\Program Files\BioStar\server\ and run file DBSetup.exe

    6. The system will ask "Do you want to install MSSQL?" Choose "No"

    7. Then a window will pop-up. Choose Database MySQL and Insert Host, Port, ID and Password.

    8. Startup the Biostar Server Service.

    9. Open Client Login and try to Login.

    Hopefully this answer will be beneficial to everyone.

    p/s: The most important is the odbc version (refer above step 2)