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
Post a Comment