OK... ODBC & mySQL 4.0....

[hand471037]

Anyone out there using mySQL and ODBC? I've gotten mySQL running on my laptop as a local service, and I've gotten the ODBC sql driver installed on my laptop as well, but when I try to export from Revit to the ODBC sql driver it simply crashes out Revit with a 'minidump' or some such error.

If anyone has any experance with this, is it due to my ODBC driver not set up right, my SQL database being not set up right, or simply a problem/bug?

[Phil Palmer]

Jeff,

We use ODBC export to a standard SQL database all the time.
We have not had any problems with Revit crashing out when exporting to the DSN once its set up. We have no experience of MySQL though.
Just to let you know to standard SQL database it works a treat

[hand471037]

well, mySQL is a standard SQL. If by 'standard SQL' you mean Microsoft's, then no, that's not what I'm trying to use, but there are a couple of SQL's out there...

Anyways, so you're going the DSN route, and not the 'Machine Source' route? Maybe that's where my problem is. I don't fully understand the difference, and need to do more research (unless some kind soul wishes to post here ;) )

[GuyR]

Jeffrey,

I take it by 'ODBC sql driver' you mean this http://dev.mysql.com/downloads/connector/odbc/3.51.html

FYI I couldn't get Revit to export to to mySQL via ODBC when I last tried it with V4 of Revit. I never worked it out and moved away from storing in a DB soon after so didn't try and work out what was wrong.

In microsoft's eye's ADO is the future so you might want to try http://sourceforge.net/projects/mysqlnet/ which if it works would give you the useful choice of postgrel or mySQL.

If you're accessing ADO via a scripting language (VB,py,rby etc) ADO is easier once you get a handle on it. In 3-4 weeks I'll be releasing something that will show you how to do it with python if you can wait :-)

HTH,

Guy

[hand471037]

Guy, thanks for your great info. It's good to know that I'm not insane, and that someone else couldn't get it to work either (someone with a lot more database experance than I).

What I'm looking for is a free open source database software that's easy to use and 'monolithic' (ala Access) to dump Revit data to ala ODBC to put together a complex demo of what you can do with Revit data.

I was hoping that mySQL could work, but so far it hasn't. I can dump the data out of Revit and then import it into mySQL, but I can dump directly from Revit to mySQL without a crash. Grrrr.....

[GuyR]

I can dump the data out of Revit and then import it into mySQL, but I can dump directly from Revit to mySQL without a crash.

What do you mean? Do you mean Revit -> access.mdb -> mySQL ?

have you tried the mySQL newsgroups? I suspect Revit is making an ODBC call which the mySQL ODBC driver doesn't support.

Have you tried postgrel? It's a debate at religous levels but some would say PG is better... Certainly runs on linux, OSX, MS.

Guy

[Marek Brandstatter]

Check out MSDE 2000

Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, redistributable version of SQL Server that’s ideal for client applications that require an embedded database, new developers learning how to build data-driven applications, and Web sites serving up to 25 concurrent users.

http://www.microsoft.com/sql/msde/default.asp

[Scott D Davis]

If you buy E-specs, you get a copy of MSDE with it.

[hand471037]

Guy, thanks for the tip. I'm database agnostic, so postgrel might be the way to go.

Marek, thanks for the suggestion, I'm looking to do this with something free if I can. Otherwise I'll get work to buy me a copy of Access. Part of this effort is to create a demo file showing people what can be done with ODBC exporting, and I want it to be either in a very common format (so I can give it out to folks) or done in something opensource (so that I can give the whole thing out)...

[hand471037]

OK, so I'm reviving this 'dead' topic:

Can someone at Autodesk confirm this 'bug' that Revit won't export to mySQL?

It's a big issue for us now.

We're exporting fine to Microsoft's SQL. But if I use the standard mySQL ODBC driver for Windows (which works for everything else) it doesn't work for Revit. This is a major pain for us, and impacts our future work, for we'd like to be able to use ODBC to export Revit models to ANY database we might need, not just Microsoft's SQL.

[mschroeder]

Did you ever get the Revit ODBC export to work with a MySQL DB? I've tested with MySQL 5 through the ODBC connector with limited success. Revit 9.1 experiences a fatal error if you try to export more than once in a session.

[hand471037]

Did you ever get the Revit ODBC export to work with a MySQL DB? I've tested with MySQL 5 through the ODBC connector with limited success. Revit 9.1 experiences a fatal error if you try to export more than once in a session.

I never did. Sadly. But then I haven't tried in a year or two. I submitted it to Autodesk as a bug, and I don't think anything ever happened about it.

[cphubb]

Jeffery,

I have had multiple problems with the mySQL ODBC driver from many applications including Revit. I suspect the driver not Revit. I have pretty much given up on mySQL because of all the problems I have had with it running on windows and moved to a (choke) MS product. I looked at the source code for the drive and could not find anything that openly looked incorrect, but had many problems with PHP ASP and VB programs accessing the db via ODBC. (Whew too many acronyms)

[hand471037]

Yeah, it's funny. I never had a single problem with mySQL and PHP when doing CMS things for our website. Even local testing versions running on IIS and Windows locally in the past worked. But ODBC and MySQL didn't seem to work so hot. Go figure.

[Ruben]

Jeffrey,

A couple other excellent free databases you may want to try are Firebird (look for the Embedded version):

http://www.firebirdsql.org/

and Sqlite:

http://www.sqlite.org/

I have no experience doing what you are trying to do, but I know these two databases are used successfully in quite a few desktop applications. I hope they work for you.