CGTalk - SQL in Max 8

View Full Version : SQL in Max 8

thatoneguy

06-13-2006, 10:00 PM

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.

Jeff_hanna

06-14-2006, 02:56 PM

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.

thatoneguy

06-14-2006, 04:42 PM

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!

CGTalk Moderation

06-14-2006, 04:42 PM

This thread has been automatically closed as it remained inactive for 12 months. If you wish to continue the discussion, please create a new thread in the appropriate forum.