When I try and run the Revit DB link it wants to create a a data source to SQL Server how do I get aroud this or how do I use this to work for me?
I’m not familiar with a SQL at all please Help..
There is a posting on the Revit Clinic that I believe should address your question:
If all that is available is an SQL Server database link and you aren't able to create an Access MDB connection, I believe your issue is that you are running a 64-bit machine without a 64-bit Access driver. The article linked above has information for this as you'll likely need the Microsoft Access Database Engine 2010 Redistributable if you want to connect to a microsoft access database.
If you wish to connect through SQL Server, you'll need to have it installed:http://wikihelp.autodesk.com/Revit/enu/2013/Help/0
SQL Server Express is available through the links below:
SQL SERVER 2005: http://www.microsoft.com/en-us/download/details.as
SQL SERVER 2008: http://www.microsoft.com/en-us/download/details.as
I have been playing around with DB Link for the past 6 months, mostly into SQL Server. My end goal is to be able to have a simple front end for non-Revit users to be able to edit and manipulate data. I am new to the world of databases. I have been successful doing the exports, edits, and imports on my machine. However, before I get ahead of myself I need to know if the SQL server and data source have to reside on the same machine as Revit in order for DB Link to work?
I never had much success with the SQL, but I exported the DB to MS access and made a link to excel but from what I could gather from access/excel forums it is better to manipulate and run access itself for a front end.
There is another alternative; to write a macro in Revit to export multiple schedules at once and another macro in excel to import them in your required format.
AS far as SQL I would be of no use to your question.
Maybe someone else can help?
I am interested in your alternative. Can you explain what you mean by "import them in another format". I am aware that Revit supports macros but what other "format" can be imported into it?
Okay if that is the case, as far as I know you can do a schedule export into a .txt file except for the RDB add on.
What I did was to run the RBD link into MS access and I used excel as a front end. I wrote a macro to do the layout and the look the “Format” of the spread sheet as I required. i.e Duct sizes into a certain category that uses a aspect ratio to define the category of the ducting from the database in MS access.
So I what I meant by format was a “MS excel-cell” format rather than a file extension “format” does that answer your question?
I am still very novice on Revit macro but I may be able to help you with a excel macro.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.