We help IT Professionals succeed at work.

How can be Autocad file store in a Database ?

interbus
interbus asked
on
Medium Priority
218 Views
Last Modified: 2010-04-30
How I can store Autocad dwg in a database, How I can retrive the drawing.
Comment
Watch Question

You can store it in a BLOB

Binary
Large
OBject.


This site has an example of using Visual Basic to store and retrieve a BLOB:

http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html

Author

Commented:
I need to store in Access or SQL Server database.

Author

Commented:
There an example by visual basic
For Microsoft SQL and VB there is an example here:

http://support.microsoft.com/kb/258038

For access ... I don't think they support the datatype.. What you can do is store the path to an actual file.  So you don't have the blob in the DB but you do have:

"C:\MyFolder\Archive\Autocad.dwg"

and then your program follows that path to get the object.
Commented:
In Access you can store data such as this in a field defined as an OLE Object

Details of how to do it can be found here:

http://support.microsoft.com/kb/103257/en-us
Forced accept.

Computer101
EE Admin

Explore More ContentExplore courses, solutions, and other research materials related to this topic.