App to Query MySQL via OLE
Posted on 2003-12-11
We need to script an application for 3D Studio Max (MaxScript) that can query and update a MySQL database. MaxScript does not have ODBC support :(, but it does allow us to send calls to other applications via OLE.
My question is whether anyone can suggest a bare bones database query application which we could use to pass data to and from 3D Studio via OLE?
Maxscript can create and release OLE objects as in the following example:
ExcelApp = CreateOLEObject "excel.application"
ExcelApp.Visible = true
ChartTypeVal = -4100
(ExcelApp.Range "a1").Value = 3
(ExcelApp.Range "a2").Value = 2
(ExcelApp.Range "a3").Value = 1
We just need a minimal application that will allow us to pass SQL queries to our MySQL database. (We don't want to use Excel.)