Revit 2011 and Database (DB) Link for 64 bit

You are not logged in currently. If you are not already a member, please take a moment a complete our free registration (a valid email is required to verify your registration). Once you complete 2 minute registration process, you will be able to create new threads, reply to threads, rate and subscribe to threads, and much more.

If this page has helped you, be sure to give it a google "+1", by clicking the icon to the right or anywhere you see it on this page.

6/30/2010 1:38:36 PM
superJMuser 433 Posts Joined 08/19/2009 www.revitinfo.com Entry Type: Feature Category: Plugins/Add-ons Subcategory: Misc	Repost: Revit 2011 and Database (DB) Link for 64 bit (Source Link) Playing catchup...here's another good post by the Revit Clinic! Revit 2011 and DB Link for 64 bit The other day I helped out with the Q and A portion of a webcast by Amy Fietkau (of Ask Amy) on the Revit DB link extension that is available on the Subscription Center. The DB Link tool is a great little add on for Revit products that allows you to connect your Revit model to a external database. The most common questions that I have seen are about setting up the database and 64 bit Operating Systems. It can be a little tricky if your not a regular database user (I fall into this group!). There were a lot of great questions and a few good tips during the webcast so I want to make sure to get some of them out there and hope they help you use the tool. If your interested in what the tool can do, you should check out two videos that Inside the Factory put together. They show what you can use the tool to do with Revit. Revit as a Database Revit as a Database Part 2 One of the questions I hear a lot is “What about using Revit DB Link with a 64 bit OS?” I’d have to say that Revit DB link works the easiest with a 32 bit OS. A 64 bit OS can be used, but there are some things that will make it trickier and a little bit more trial and error will be needed. If you are using Office 2010 it makes it a little bit easier, but not fool proof. The issue is that until Office 2010 came out, Microsoft did not provide the 64 bit ODBC drivers needed to connect to a Access Database or to Excel. You had to use a different database, like SQL Express, to connect to it. With the release of Office 2010, they released the drivers needed to connect ODBC with Access and Excel. If you don’t have Office 2010, you still can download and install the Microsoft Access Database Engine 2010 Redistributable so that you should be able to setup the connection. I actually haven’t tried this download myself yet though. Even with Office 2010 installed, you will have to setup a ODBC connection (the MS Access Tab in the DB Link tool will be blank) in order to connect to a data source. I ran across a good blog post the other day that walks through the setup. Update on DB Link – using 64 bit ODBC drivers If you want to use SQL Server as your connection, I was able to find another blog post (its in French, but can be translated) that explains the setup process pretty well. Tools Q3: RDBlink I’ve been messing around with SQL Express 2008 and the key for me has been making sure that I was using SQL Server Management Studio. Having Management Studio made all the difference for making the connection and setting it up (without it, I was quite literally stuck). Last, but not least, a quick troubleshooting tip you can use when trying to work out a problem with exporting or editing/importing via the DB link tool is to see if you can export your model via the ODBC export option in the Application Menu. This can help boil it down a little bit and see if the problem is with Revit or the ODBC connection. I’d be interested in hearing about your experiences with the Revit DB Link tool and why you have used it, so please submit your comments. ____________________ superJMuser www.revitinfo.com

No records found

Speed in Bim for custom Windows/Doors 2!

hatch22 - a revit hatch pattern tool

hatch22-2012 - Fill Pattern Generator

Parameter Jerk 2012 Released

Custom Selection Sets in Revit Saved for Future Resuse

DCStrategies FREE Revit plug-ins

You must be a registered user to Rate entries. Please take a moment a complete our free registration (a valid email is required to verify your registration).

You must be a registered user to Subscribe to individual entries. If you would like, you can subscribe to all future new posts and/or replies by filling out this form. Otherwise, take a moment a complete our free registration (a valid email is required to verify your registration).

Below is a list of things to be aware of when browsing through the Revitinfo.com Forum:

1) As a registered user at Revitinfo, you automatically are signed up to recieve emails any time a new post or reply to existing post is made. You can change this setting while logged in under your User Profile by clicking on your user name at the top right of any page, next to the Date (or by clicking on the My Profile Button on any Forum Page). Once you get here, click on the "Edit Profile" link below your Quick Profile Information. Finally, select "Manage Profile" and scroll down the the very bottom to change your forum email subscription Settings.

2) Each Entry must have an assigned Category and EntryType. Not all categories have subcategories, but if the category you pick has subcategories, please pick the most appropriate for your entry.

3) Only registered, logged-in users have the privledges to create posts, reply to posts, and view attachments of posts. Registration is free, and like any other forum, is our way of increasing forum functionality and security.

4) As a registered user, you will also have the ability to subscribe to threads individually, rate them, and view a list of your posts. You can also edit posts that you have made. Also, as a registered user at Revitinfo, you automatically are signed up to recieve emails any time a new post or reply to existing post is made. You can change this setting while logged in uder your User Profile by clicking on your user name at the top right of any page, next to the Date. Once you get here, click on the "Edit Profile" button below your Quick Profile Information. Finally, select "Manage Profile to change your profile Settings.

5) Soon, there will be a way for users to request other categories/SubCategories via a request form. Currently, for our system to work the way it has been designed, the category and subcategories as well as EntryTypes must remain a standard for all users of the site, in order to make searching/browsing information faster and easier.

Revit 2011 and DB Link for 64 bit