topic Re: Issue in connecting to Oracle Database in .NET Forum

Issue in connecting to Oracle Database

zoomkey — Fri, 12 Apr 2024 13:50:25 GMT

AutoCAD .NET application written in C# which runs through AcCoreConsole doesn't connect to Oracle 19c Enterprise Edition in a Windows Server 2019. However, other .NET applications deployed here in this Windows Server 2019, is able to connect to Oracle DB without any issues.

It fails during the opening the Connection. It always throws an "Connection request timed out" error. I've tried installing the ODAC components and set the Environment Path to the Oracle Folder, but all in vain.

Did some research and found this, Connecting to Oracle Database , but can't able to figure it out.

Am I missing something?

Re: Issue in connecting to Oracle Database

norman.yuan — Fri, 12 Apr 2024 16:07:40 GMT

So, you are running AutoCAD core console on a server computer, which directly connect to a database server (Oracle). It is obviously hard to deal with: one cannot debug in this case, nor other can help/suggest in meaningful way. So, you should do your work toward the issue like this:

Run/debug your CAD plugin in desktop AutoCAD session. This way, you can easily tell if the plugin can connect to the database server or not. If not, what the error is (commonly, it is either credential, or network issue). Once it is able to connect, you run the plugin locally in the computer you logged in to confirm the connect is OK. Then you try to run the core console on server computer with an appropriate user account that is known to have the required authorization to connect to the database server.

Re: Issue in connecting to Oracle Database

zoomkey — Fri, 12 Apr 2024 16:55:46 GMT

Sure. Thanks for the suggestions. Will try and revert.