Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: OK... ODBC & mySQL 4.0....

  1. #1
    AUGI Addict hand471037's Avatar
    Join Date
    2003-05
    Location
    Oakland, California
    Posts
    1,934
    Login to Give a bone
    0

    Default

    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?

  2. #2
    I could stop if I wanted to
    Join Date
    2003-04
    Location
    London NW9
    Posts
    377
    Login to Give a bone
    0

    Default Re: OK... ODBC & mySQL 4.0....

    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

  3. #3
    AUGI Addict hand471037's Avatar
    Join Date
    2003-05
    Location
    Oakland, California
    Posts
    1,934
    Login to Give a bone
    0

    Default Re: OK... ODBC & mySQL 4.0....

    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 )

  4. #4
    AUGI Addict
    Join Date
    2003-11
    Location
    New Zealand
    Posts
    1,116
    Login to Give a bone
    0

    Default Re: OK... ODBC & mySQL 4.0....

    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

  5. #5
    AUGI Addict hand471037's Avatar
    Join Date
    2003-05
    Location
    Oakland, California
    Posts
    1,934
    Login to Give a bone
    0

    Default Re: OK... ODBC & mySQL 4.0....

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

  6. #6
    AUGI Addict
    Join Date
    2003-11
    Location
    New Zealand
    Posts
    1,116
    Login to Give a bone
    0

    Default Re: OK... ODBC & mySQL 4.0....

    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

  7. #7
    I could stop if I wanted to Marek Brandstatter's Avatar
    Join Date
    2003-08
    Location
    Johannesburg, South Africa
    Posts
    214
    Login to Give a bone
    0

    Default Re: OK... ODBC & mySQL 4.0....

    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

  8. #8
    Revit Technical Specialist - Autodesk Scott D Davis's Avatar
    Join Date
    2003-04
    Location
    Chino, CA
    Posts
    4,756
    Login to Give a bone
    0

    Default Re: OK... ODBC & mySQL 4.0....

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

  9. #9
    AUGI Addict hand471037's Avatar
    Join Date
    2003-05
    Location
    Oakland, California
    Posts
    1,934
    Login to Give a bone
    0

    Default Re: OK... ODBC & mySQL 4.0....

    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)...

  10. #10
    AUGI Addict hand471037's Avatar
    Join Date
    2003-05
    Location
    Oakland, California
    Posts
    1,934
    Login to Give a bone
    0

    Default Re: OK... ODBC & mySQL 4.0....

    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.

Page 1 of 2 12 LastLast

Similar Threads

  1. Access to Mysql
    By engineering.28250 in forum AutoCAD Map 3D - General
    Replies: 1
    Last Post: 2010-03-11, 10:15 PM
  2. odbc export to mysql database - error
    By andreseifert in forum Revit Architecture - General
    Replies: 0
    Last Post: 2010-01-31, 09:28 AM
  3. ODBC & MYSQL - Getting Desperate
    By Frederick in forum Revit Architecture - General
    Replies: 4
    Last Post: 2006-05-12, 10:51 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •