View Full Version : .getrows() crashing max

01 January 2008, 07:52 PM
I'm trying to run my old:

MySQL code for a complete pipeline automatic suite I'm starting but it's crashing on the

recordSet.Open "SELECT * from TestTable" TestConn

Any ideas on what might be causing that? It seems to be in a loop of some sort. But I don't know why that would be.

Hmmm it would seem that it's inside the ODBC driver. I'm on XP64 and I think it might be trying to return data from the x64 driver inside of max 32bit... causing unexpected crashiness.

01 January 2008, 08:31 PM
-- Error occurred in anonymous codeblock; filename: ; position: 47
-- Runtime error: OLEObject method call failed:
Error Message 1: Provider is not specified and there is no designated default provider.
method: open()

I installed a 64 bit ODBC driver instead and am using Max 64. But now it's not recognizing the 64 bit driver. I think it's looking for the 32 bit ODBC driver but not finding it. But why would max 64 look for a 32 bit driver for its ODBC handling in MaxScript?

3D Studio Max 10 32 bit finds the 64 bit driver fine... which it shouldn't.

02 February 2008, 06:54 PM
I got it to work. The solution?

Use a differeint MySQL/Apache package.

EasyPHP 2.0 is now my recommended software package.

02 February 2008, 06:59 PM

If you're using max 9 or later, you should try the MySQL .NET connector. I've had better success using it than using activex solutions.


02 February 2008, 02:14 AM
Do you still need ODBC or can it connect natively? Not needing an ODBC driver would be great.

02 February 2008, 02:45 AM
Do you still need ODBC or can it connect natively? Not needing an ODBC driver would be great.

You don't need ODBC, it allows you a direct connection to the DB.

CGTalk Moderation
02 February 2008, 02:46 AM
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.