AutoCAD Map 3D Developer
Welcome to Autodesk’s AutoCAD Map 3D Developer Forums. Share your knowledge, ask questions, and explore popular AutoCAD Map 3D Developer topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Best Approach for External Database Use in Map 3D

1 REPLY 1
Reply
Message 1 of 2
Anonymous
496 Views, 1 Reply

Best Approach for External Database Use in Map 3D

Anonymous
Not applicable

I am attempting to update a rather old ARX extension designed for use with Map 3D. It connects drawings to an external Oracle database, part of a facilities management system. The ARX is entirely written in C/C++, and has had many and varied developers' fingers in it over the years. Its database work is implemented using the ASE/ASI approach, which was deprecated in 2000, and finally removed in 2018. As a result, the last functional implementation of the ARX was for Map 2017.

 

Since ADO is deprecated, and even OLEDB was deprecated by Microsoft (but supposedly brought back to life) my thinking is to move all the external database handling to a separate DLL, and to re-implement all the Oracle work using ODBC and the standard MFC database classes (CDatabase/CRecordset/etc.). Feel free to tell me if I'm way off-base in this approach.

 

However, some of the work done in this ARX pre-dates any version of the Map ObjectARX SDK that I have been able to find, and it seems that the best documentation is only in very old versions. I have standard ObjectARX files going back to the 2000 timeframe, but nothing for Map from before 2007. I'd appreciate it if anyone could point me to a download location for the older info.

 

As well, please feel free to offer up hints/suggestions/derisive laughter.

Best Approach for External Database Use in Map 3D

I am attempting to update a rather old ARX extension designed for use with Map 3D. It connects drawings to an external Oracle database, part of a facilities management system. The ARX is entirely written in C/C++, and has had many and varied developers' fingers in it over the years. Its database work is implemented using the ASE/ASI approach, which was deprecated in 2000, and finally removed in 2018. As a result, the last functional implementation of the ARX was for Map 2017.

 

Since ADO is deprecated, and even OLEDB was deprecated by Microsoft (but supposedly brought back to life) my thinking is to move all the external database handling to a separate DLL, and to re-implement all the Oracle work using ODBC and the standard MFC database classes (CDatabase/CRecordset/etc.). Feel free to tell me if I'm way off-base in this approach.

 

However, some of the work done in this ARX pre-dates any version of the Map ObjectARX SDK that I have been able to find, and it seems that the best documentation is only in very old versions. I have standard ObjectARX files going back to the 2000 timeframe, but nothing for Map from before 2007. I'd appreciate it if anyone could point me to a download location for the older info.

 

As well, please feel free to offer up hints/suggestions/derisive laughter.

Labels (1)
1 REPLY 1
Message 2 of 2
lena.talkhina
in reply to: Anonymous

lena.talkhina
Alumni
Alumni

Hello @Anonymous !

Great to see you on Autodesk Community forums!

 

There are specifics for Map 3D, but maybe programmers from ObjectARX forum could help you?

Находите сообщения полезными? Поставьте "НРАВИТСЯ" этим сообщениям! | Do you find the posts helpful? "LIKE" these posts!
На ваш вопрос успешно ответили? Нажмите кнопку "УТВЕРДИТЬ РЕШЕНИЕ" | Have your question been answered successfully? Click "ACCEPT SOLUTION" button.



Лена Талхина/Lena Talkhina
Менеджер Сообщества - Русский/Community Manager - Russian

0 Likes

Hello @Anonymous !

Great to see you on Autodesk Community forums!

 

There are specifics for Map 3D, but maybe programmers from ObjectARX forum could help you?

Находите сообщения полезными? Поставьте "НРАВИТСЯ" этим сообщениям! | Do you find the posts helpful? "LIKE" these posts!
На ваш вопрос успешно ответили? Нажмите кнопку "УТВЕРДИТЬ РЕШЕНИЕ" | Have your question been answered successfully? Click "ACCEPT SOLUTION" button.



Лена Талхина/Lena Talkhina
Менеджер Сообщества - Русский/Community Manager - Russian

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report