Search the Community
Showing results for tags 'dbconnect'.
Found 3 results
How to use DBConnect with Oracle
newCADuser posted a topic in AutoCAD Drawing Management & OutputHello I am Oracle DB Administrator and no knowledge about autoCAD. i have a new requirement from company to save a static drawing's dimensions' data into DB table. We have hundreds of drawings. DBConnect connects with oracle using ODBC. But how it is possible that we draw a drawing and its attributes are saved in DB. Any document, tutorial which may help... Thanx ahead.
dbConnect Query like: SQL SELECT COUNT(*), SUM(*) FROM GROUP BY
gnurob posted a topic in CAD ManagementHaving some fun with dbConnect... it appears pretty easy to gather information from a database and apply it to a DWG, however it doesn't seem possible to summarize that data (e.g. "how many of these objects are in drawing"). For example, if the database contained window information and several types of windows were used multiple times, it should be possible to link each window to the database and then query the drawing to determine the number of each, and total cost. Window Count Cost Total TypeA 5 $250 $1250 TypeB 7 $200 $1400 Failing that, if the database could be updated (actually, this would be much better) with a new record for each new object, the database could perform the summary (and many other useful things). However, its appears the "Link..." can only pick an existing record from the database. Both seem unavailable from what I've seen of the application and the documentation. Please tell me I'm wrong! :-) IMHO, its surprising that attribute definitions are capable of so much more. Filling tables, linking to Excel, etc., should be small time for a database connection. Thanks
break ole link to one object
rleap posted a topic in AutoCAD GeneralI have an Acad2011 drawing with objects linked to a MS Access 2010 BOM database table via dbconnect. I have created my links successfully. However, I occasionally need to break a single object's link to its corresponding record either due to an error or change. A database record may sometimes link to multiple objects. How do I break just the one link while leaving the other objects' links intact.