ODBC & MYSQL - Getting Desperate

[Frederick]

Has anyone been able to set up an ODBC link to MYSQL from Revit? I desperately need to get this working and would appreciate any help. It seems like MYSQL is incompatible with the Revit ODBC, but I'm not sure.

Thanks!

Frederick C. Gibson, Architect

Frederick@gibson-design.com Architecture Designed With Integrity
===========================-------------------------------||||||||||||||
Frederick Clifford Gibson Architect & Associates

679 Harrison Street
San Francisco, CA 94107
415.227.1684 |tel| 415.227.1685 |fax|

ul. Micinskiego 8
91-160 Lodz, Poland
48.42.656.0752 |tel/fax|

(c)2006 http://www.gibson-design.com

[Tom Dorner]

I don't have time to test it right now, but if you have a proper DSN established then everything should work just fine. Check out the following for MyODBC DSN setup:

http://dev.mysql.com/doc/refman/5.0/en/dsn-on-windows.html

[GuyR]

Last time I tried MySQL was V5 and it didn't work then. Never tried to find out why. I think Jeffrey McGrew also has tried it I think. You could try contacting support. Note: You could do it via the API but I suspect this isn't want you want. Also if you don't need MySQL you could try Postreql (http://www.postresql.org/) .

[Frederick]

Hi Tom,

Thanks for the link. I have the DSN up and running and it tests out successfully. Still no success from the Revit side. I get this error: [HY000] [MySQL][ODBC 3.51 Driver]User cancelled. (0)
. Maybe this is a MySQL problem? I'll try to post there and see if I can get an answer.

[Frederick]

Hi Guy,

Our entire office intranet database runs on MySQL - and it works very well. Our in house lisp server and lisp application runs on top of MySQL, so I really need to get the Revit link running with MySQL although I've heard good things about Postgresql too.