Link object data with Sql Server

[Azman Ali]

Dear Sir,

I already have drawing in Autocad Map 3 and now i would like to link
with Sql Server 6.5. In the drawing I already enter id for each object
in object data. In Sql Server also have a field for id that i entered in
object data in Autocad Map.
I not sure how to link this drawing and Sql Server.

Please Assist Me. Thank You For Your Cooperation.

Azman Ali
az...@sysdeco.infomal.com.my

[Marion Pietsch]

Ali,

attach the database table to your drawing and create an LPN on the ID field.

As soon as the connection to the table is established you can use the
'Generate Links' (ADEGENLINKS) command to automatically link your table
records to the appropriate id numbers in the dwg.
For more information on how to do this, please, have a look at Chapter 10 -
Working with External Databases and Chapter 2 - Tutorial 3 of Map's User
Guide.

Marion Pietsch
WW Support & Services
Autodesk GIS Product Support

[jagur]

Marion Pietsch wrote:

> Ali,
>
> attach the database table to your drawing and create an LPN on the ID field.
>
> As soon as the connection to the table is established you can use the
> 'Generate Links' (ADEGENLINKS) command to automatically link your table
> records to the appropriate id numbers in the dwg.

I have the same problem, when I want to create links between external database
and object data. There is no problem to generate links with block, text, closed
text or closed block Same problem when I export object data to external
database with generate link via handle (it looks like link in WORLD). How to
link this database in new project?

[Marion Pietsch]

Azman, Jagur,

sorry for having misunderstood you...
The easiest way to combine object and external attribute data would be to Convert
Object Data to Database Links and then merge the tables in SQL Server or any other
database your're using for your external database tables.
In MS Access for example you could create a query where all columns of both tables
are selected to get the tables united, in Oracle and probably also SQL Server you
could do a Union to get tables merged.
Then link the expanded or newly created table to you object entities via the ID.
The only way to merge tables inside of Map is when overlaying topologies what might
not match your tasks.

Marion Pietsch
WW Support & Services
Autodesk GIS Product Support