Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 19 May 2024 11:19:23 +0000

How to Post a Message for Support

Post From: Connecting to external MySQL database server

[2013-11-04 11:14:14]
[Go To First Post]
ChrisR - Posts: 7
Thanks

I tried to use headers from the MYSQL connector, but I am not experienced enough with C++ to make it work with that approach.

However I have compiled an external executable that connects to the remote MYSQL database and is then called and passed parameters from within SC using the system command i.e.


if (sc.Index == 0) {  
    SCString exeFile = "c:\\dbconnector\\remote_database.exe";
    SCString symbol = sc.Symbol.GetChars();
    SCString runExe = exeFile + " \"" + symbol + "\"";

    system ( runExe );
  }

This seems to work well.
Date Time Of Last Edit: 2013-11-04 11:14:43