Discussion:
connection to database on different machines
(too old to reply)
Jan-Mikael
2005-02-03 09:18:28 UTC
Permalink
Hi!
I'm very new at this so i will try to explain what i'm trying to do.
Let's say i want to make a qurey from my SQL database to my drawings. For instance i might want to ask questions like.."is there an attribute 0102 in the drawing?" or "how many occurences of the object window is there in the model?" Is this possible to do.?..after all you have to access the info within the dwg-file. The drawings are located in the same database i want to make a query from. I Hope you understand what i mean..i usually work with modelling, visualisation etc so this is kind of out of my experties..

well..ideas anyone?
Jon Fleming
2005-02-03 13:22:27 UTC
Permalink
Although AutoCAD drawings are sometimes referred to as databases, they are not
relational databases, and there are no facilities for making SQL queries against
AutoCAD drawings.

There are things that could be done with custom programing in VIdual Basic, VBA,
Delphi, C++, and maybe some other languages. But to do it with SQL you'd need an SQL
inerperter and a program that could search the AutoCAD drawing file. Autodesk does
sell an API for the latter, called ObjectDBX.
--
jrf
Autodesk Discussion Group Facilitator
Please do not email questions unless you wish to hire my services
Post by Jan-Mikael
Hi!
I'm very new at this so i will try to explain what i'm trying to do.
Let's say i want to make a qurey from my SQL database to my drawings. For instance i
might want to ask questions like.."is there an attribute 0102 in the drawing?" or
"how many occurences of the object window is there in the model?" Is this possible
to do.?..after all you have to access the info within the dwg-file. The drawings are
located in the same database i want to make a query from. I Hope you understand what
i mean..i usually work with modelling, visualisation etc so this is kind of out of
my experties..
well..ideas anyone?
Loading...