PDA

View Full Version : .getrows() crashing max


thatoneguy
01-09-2008, 07:52 PM
I'm trying to run my old:
http://forums.cgsociety.org/showthread.php?f=98&t=384588

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.


Edit3:
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.

thatoneguy
01-09-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.

thatoneguy
02-27-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.

ofer_z
02-27-2008, 06:59 PM
Hi,

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.


cheers,
o

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

ofer_z
02-28-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-28-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.