Not able to connect from excel(2003) to oracle server -


I am trying to connect to Oracle server from Excel ... I do not have to install a viunal client in my system (I do not currently have an Oracle client there) I am using Microsoft ODBC for Oracle

  Slow Structures, Con, RS, Stroskol StraconAction = "Driver = {Oracle for Microsoft Odbc} server = servername; uid = use Name "PWD = password," set conn = CreateObject ("ADODB.Connection") conn.Open strConnection 'insq = "Enter state (states) values ​​(' + Sheet 1. Seals (1, 5) + '') "'Conn.execute insq conn error set: Oracle client and networking component is not found  

I have also tried to use connection string

  TrConnection =" provider = OraOLEDB.Oracle; Data Source = Data Source; User ID = Username - Password = Password; " 'StrokeAction =' provider = MSDORA; Data source == data source; User ID = Username; Password = password; " 

But I am still getting an error

My main question is that we have no connection with Oracle server from Excel to our system without any Oracle client

Eventually you need something on your system To begin 'Oracle speaks' it is important to know how the protocol works to get the specific password accepted by Oracle Even before doing anything with the data.

You are better than installing (Basic and Odbc supplement).


Comments