I’m interested in the SQL functionality in Max but I can’t find very much information in the documentation.
There is a section titled: SafeArrayWrapper Class Which seems to incidentally discuss the topic, but to me at least doesn’t seem to really cover the topic clearly.
Is there a better section of the documentation that I can’t find that goes in depth?
Also, does anybody know if the maxscript implementation is SQL server agnostic, in that can I use MySQL or does it have to be an Oracle or Microsoft server?
If someone has gotten a script to work, I would really appreciate some reference code to deconstruct.
The SafeArrayWrapper Class topic in the help file has sample code for talking to a SQL database and lists OLE DB and ODBC connection strings for quite a number of different database sources. While I don’t see MySQL on the list if you can get to it via OLE DB or ODBC you should be able to talk to it via MXS. You’ll just need to figure out the connection string on your own.
Ok I found a couple of options for an OLE wrapper. Thanks, that page will be sufficient, I misinterpreted some of the OLEDB commands as MaxScript specific, not recognizing them as SQl. Thanks!