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(265.6, 43%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Hello, I have installed MicrosoftSSISOracleConnector-SQL22 v1.2 (64-bit) on Microsoft SQL Server 2022. Everything was working fine until I used failover=on in the tnsnames.ora and the first service in the list was unaccessible. It can be tested by creating new DSN using this driver and changing the order of the accessible and unaccessible services with failover=on parameter. When using the same list in the tnsnames.ora and the first service is accessible the connection is successful. Is it fixed in v1.3 or the issue is still present?
Hi @Dragana Popovic, I haven't found the release note for Microsoft Connector for Oracle V1.3. You may install the v1.3 for a try. Regards， Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
Hi @ZoeHui-MSFT
V1.3 is available here: https://www.microsoft.com/en-us/download/details.aspx?id=105811
One of the enhancements is:
I will give it a try and let you know
The issue with failover not working while using TNS connection list, when the first node in the list is not accesible, is resolved in Microsoft Connector for Oracle V1.3 due to enhancement in: