无法从excel(2003)连接到oracle服务器 [英] Not able to connect from excel(2003) to oracle server

问题描述

我正在尝试从excel连接到oracle服务器...我不想在我的系统中安装oracle客户端(目前没有oracle客户端)所以我正在使用Microsoft ODBC for Oracle

I am trying to connect to oracle server from excel...i dont want to install oracle client in my system(presently there is no oracle client) So i am using Microsoft ODBC for Oracle

 Dim strConnection, conn, rs, strSQL
 strConnection = "Driver={Microsoft ODBC for Oracle};Server=ServerName;Uid=username;Pwd=password;" 
Set conn = CreateObject("ADODB.Connection")
conn.Open strConnection
'insq = "insert into State (States) values ('" + Sheet1.Cells(1, 5) + "')"
'conn.Execute insq
conn.Close
Set conn = Nothing  

错误是:找不到Oracle Client和网络组件

The Error is : Oracle Client and networking component not found

我也尝试过使用连接字符串

I have also tried using connection string

trConnection = "Provider=OraOLEDB.Oracle;Data Source=Datasource;User  Id=username;Password=password;"
'strConnection = "Provider=MSDAORA;Data Source==Datasource;User Id=username;Password=password;"

但是我仍然遇到错误

我的主要问题是我们可以在没有oracle客户端的情况下从excel连接到oracle服务器吗? 在我的系统中.

My main question is can we connect from excel to oracle server without oracle client in my system..

推荐答案

最终，您的系统上需要说Oracle"的东西.首先，它需要知道该协议如何工作以使Oracle接受指定的密码，甚至在对数据进行任何处理之前.

Ultimately you need something on your system that 'speaks Oracle'. To begin with it needs to know how the protocol works to get the specified password accepted by Oracle, even before it gets into doing anything with data.

最好安装即时客户端(基本和ODBC补充).

You are best off installing the Instant Client (Basic and ODBC supplement).

这篇关于无法从excel(2003)连接到oracle服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！