Search the Community
Showing results for tags 'odbc'.
-
I believe I just discovered the holy grail of referencing information via remote database. To give you a representation of my workflow, I will make another post to separate it from the initial content. One of the major hardships that I have had connecting to a remote database was that the database connection was always lost upon exiting the file. If you worked remotely, this was not acceptable. One of the most common problems that comes up is this : However after tinkering around (for weeks) with the object link database, i accidently came across this (see screenshot below). This pop up only comes up when you press the object database connection when you have multiple selected objects selected. This is VERY VERY IMPORTANT Why you ask? because it renews the database connection that you established earlier and it can update the remaining database records when one common record is matched. That means - if you have thousands upon thousands or records (which i plan to have), going it through the list when you open object database connection would be a nightmare. Instead, make sure you have a record that exactly matches word for word in the database and use this dialogue to update the remaining records. I call this the HOLY GRAIL of ODBC connections because the applications are almost limitless - everything from referencing product information / ids, to materials, to building code references / uses or zoning. I am sure some of you are even more creative than me and will find even more applications. Now, if everyone has had the patience to read through this already, I have a question to the employees or anyone a little more familiar with this than me. How can the menu below be referenced by a shortcut? and can this particular function be used in a script? the reason I ask is that I plan to use this for assembly details ( i will create a separate post because it involves material libraries as well) and will use tags to reference the information - and updating the database with multiple clicks can be especially frustrating, and would prefer to use a shortcut or some quick method with a script perhaps? Anyways, I hope you find this information useful. To me it was a huge deal and thought I'd share. This post is a follow up to my previous post of setting up ODBC. I case it was missed on how to set up ODBC see below This is the process by which i access my database both locally and remotely. The database can be access via link below : sorry, this is read only. If anyone wants to experiment with this, let me know, i can provide a sample write access version. The link below is the database front end that I use to edit the database. It has its own subdomain, so it can be universally accessed and edited. And then, in turn, vectorworks can access the mysql database on a different port using the same subdomain. Therefore : enter the information via web, access the information via Vectorworks. Need to update the info ? see method above. https://db.autographarch.com/dashboard/#/nc/view/5cf8b5cb-fbe1-4532-88e7-dc4bed61eb40
-
Hi, 1rst question : Do anybody manage to use the "link to database" via ODBC on a Mac ?. Is there any precise tutorial ? the help is not complete. 2nd question : Can the database be a Synology hosted mariaDB one ?
-
Creating a database of materials and specifications unfortunately is quite a tedious task and not always can be done inside of VW. Currently, when editing properties for materials, all physical / other properties need to be filled in manually. Given the number of permutations for material properties, the task almost seems unreachable when doing this manually (also especially when needing to update the information! ) What if we could populate it from a database (say that has a list of information regarding Building product information in HEAT, AIR, and Moisture Control in Building Assemblies - material properties from ASHRAE Handbook of Fundamentals,etc..)
-
SP4 notes say ODBC connection is fixed (as did SP3), but Vectorworks is still crashing within 5 minutes of updating the drawing with data drawn from an external FileMaker database. This long-standing issue (nearly two years since successful connection) is preventing good BIM data connections for Vectorworks, a real shame.
-
Heyo, I just tried to connect VW 2019 with a Ecxel document over the ODBC connection to transfer data. I try to use this Tutorial from @Miguel Barrera The Problem I have is when try to choose the dataconnection in VW, the options are not givin: I create connections in the ODCB Manager tfor every Ecxel Driver who exist: Why isnt this working in VW? I try to run VW with Admin Rights but still no result in the list.
- 1 reply
-
- vectorworks
- odbc
-
(and 2 more)
Tagged with:
-
Version 1.0.0
86 downloads
ODBC connection is useful for those that have an external database and want to use values from it within Vectorworks. It is also helpful going the other way, allowing users to edit their external database from within Vectorworks. These are more advanced nodes that will require an understanding of setting up and working with external databases.-
- 1
-
- odbc
- productivity
-
(and 1 more)
Tagged with: