在Excel中创建与Oracle ODBC的连接时出错 [英] Error creating connection to Oracle ODBC in Excel
问题描述
Oracle数据库服务器 - 32位,操作系统 - Windows 10(64 - ),Excel Office 2010(32位)
在 tnsnames.ora
中,您应该有一个位于目标服务器中的数据库实例的条目,如:
测试=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =(PROTOCOL = TCP))(HOST = )(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
)
)
然后 tnsping测试
在 cmd
应该可以正常工作。您将在您的odbc中使用此 tns
条目。
I am trying to connect to Oracle ODBC for OraClient10g_home1 in System DSN.once done,i have tested the connection and it says connection successful.but when i try to import Oracle data from Excel's built-in function (Microsoft Query),it gives me the following error message.please let me know how to fix this issue.
Oracle Database Server - 32 Bit,Operating System - Windows 10(64-Bit),Excel Office 2010 (32-Bit)
in tnsnames.ora
you should have an entry for database instance located in target server like :
Test= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST=target server)(PORT=1521)) ) (CONNECT_DATA = (SID = orcl) ) )
then tnsping Test
in cmd
should work fine. you will use this tns
entry in your odbc.
这篇关于在Excel中创建与Oracle ODBC的连接时出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!