如何使用SSIS连接到Oracle?我收到错误消息:"tns侦听器未在connect_data中获得service_name" [英] How do I connect to Oracle with SSIS? I am getting the error: "tns listener was not given the service_name in connect_data"

问题描述

我试图通过SSIS中的OLE DB的Oracle提供程序连接到Oracle DB，但是在测试连接时遇到以下错误:在connect_data中未给tns侦听器提供service_name".我对Oracle不太熟悉，所以有人可以为我提供一些有关解决此错误的指导吗?

I am trying to connect to an Oracle DB through the Oracle Provider for OLE DB in SSIS, but am getting the following error when testing the connection: "tns listener was not given the service_name in connect_data". I am not too familiar with Oracle, so could someone provide me some direction for how to fix this error?

推荐答案

您可以在主机名之后添加服务名称，并在它们之间使用正斜杠.这在Microsoft和Oracle OLE DB提供程序中都有效.

You can add the service name after the host name with a forward slash between them. This has worked in both the Microsoft and Oracle OLE DB providers.

IP/Service_Name也可以使用"12.12.123.123/Server1.domain.com"

IP/Service_Name also works, "12.12.123.123/Server1.domain.com"

这篇关于如何使用SSIS连接到Oracle?我收到错误消息:"tns侦听器未在connect_data中获得service_name"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！