I am trying to connect with Oracle database in VS2022. When i try to create connection it says 'There was an error trying to establish Oracle connection with database server'.Please help on this

Question

I am trying to connect with Oracle database in VS2022 to create SSIS package. I have installed microsoft connector both 32 and 64bit.When i try to create connection it says 'There was an error trying to establish Oracle connection with database server'. Please help on this.

Answer 1

Hi @Priyanka R,

Connection manager information

TNS service name

Input the name of the Oracle database you work with. The TNS service name could be:

The connection name defined in the tnsnames.ora file

EzConnect format: [//]host[:port][/service_name]

To use a tnsnames.ora file, you may need to add a system environment variable to the machine running the SSIS package. The TNS_Admin environment variable specifies the location of the folder that contains the tnsnames.ora file.

Please follow this documentation and make sure you have set the manager correctly.

Microsoft Connector for Oracle

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.