Community
The Community Room
The Community Room is a space to have conversations about anything you’d like to discuss with your fellow Engineers, Architects, Designers and basically all community members in here.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Database connection - Oracle or SQL Server

6 REPLIES 6
Reply
Message 1 of 7
lucas_porto5DJ9Y
295 Views, 6 Replies

Database connection - Oracle or SQL Server

Hi, everyone.

I'm trying to connect to two different database, one in Oracle and other in SQL Server.

There are any documentation about how to do this?

Anyone can help in this topic?

Labels (1)
6 REPLIES 6
Message 2 of 7

Using what program? You will get better answers posting in the forum dedicated to that specific program.

Allen Jessup
CAD Manager - Designer
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature

Message 3 of 7

Hi Allen.

I'm using AutoCAD 2024 and Civil 3D 2024.

Message 4 of 7
pendean
in reply to: lucas_porto5DJ9Y


@lucas_porto5DJ9Y wrote:

Hi Allen.

I'm using AutoCAD 2024.


May I ask, with plain AutoCAD2024, what is the intent to connect to one of those?

are you getting into .NET programming, designing an add-on? or...?

 

Did you already look in the program's HELP to find talk about other software linking to databases by chance?

Message 5 of 7

Are you trying to query from both sources into one inside of AutoCAD or are you just wanting to be able to source two different databases?

 

If you just need to connect to two different sources, you can create several sources in tn the DB CONNECT MANAGER.

When it comes to connecting to your data if you have an ODBC set up in your system you can select the ODBC connection by selecting OLE DB PRovider for ODBC Drivers. Then, in the next dialog, you can select your data sources from the drop down. 

 

TheCADnoob_0-1729695408891.png

 

 

TheCADnoob_0-1729695232633.png

TheCADnoob_1-1729695287795.png

 

CADnoob

EESignature

Message 6 of 7

Hi @TheCADnoob , thanks for your answer.

 

I just want to be able to source two different databases.

I first tried with Oracle but the information that I found is that the version 19 (I think) don't have support.

Later I tried with SQL Server through ODBC but every time that I tried to access the database my AutoCAD ou Civil 3D stop responding.

I already read all the help for both software and don't know what can I do.

Do you have any idea about what can be happening?

Message 7 of 7

Not sure what the problem is, I would start with ODBC and make sure they are set up correctly. Can you pull data from your ODBC in other applications? Try pulling data from your two sources into another program like Excel using powerquery.

 

If it pulls into Excel fine, then the problem is in AutoCAD. 

CADnoob

EESignature

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

Post to forums  

Autodesk Design & Make Report