This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 13%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
Hi, we have installed VS2019 and we've already have oracle connetions to oracle 19c DB, but using the same method it is not working when trying to connect to oracle 11g DB.
The TargetServerVersion is changed to SQL Server 2019 and we are using the EzConnect format.
--------
Microsoft Visual Studio Community 2019
Version 16.11.10
--------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
Hi @IvaZehireva ,
Make sure that you installed the 64-bit MS Oracle Connector on the server.
Microsoft Connector for Oracle V1.0
Please also set Run64BitRuntime to true and then have a try.
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
I think we have installed Microsoft Connectors v5.0, but I have to check. Thank you for your answer!
If you are using oracle-connector, it does not have the v5.0, please have a double check.
The problem was with the servers fire wall. Thank you for your help!
using the same method it is not working
"Not working" means what in detail? Do you get an error message (which one)?
to connect to oracle 11g DB.
Do you know how old Oracle 11 is? Release was in 2008!, that's out of support: https://en.wikipedia.org/wiki/Oracle_Database
Oracle Connector
What for an Oracle Connector? By default there is no one in SSIS.
Yes, I know its old but that is the case. I'm using Oracle Source and while setting the Oracle connection Manager the error is "There was an error trying to establish an Oracle connection with the database server". We have the same connection to oracle 19c and it is working fine.
We have the same connection to oracle 19c and it is working fine.
Fine, but: Oracle 19c <> Oracle 11g; it's to old to be supported by current data provider.