Stack Overflow
Stack Overflow

Questions tagged [instantclient]

The Oracle Instant Client is an easy to install client for Oracle Databases utilizing the Oracle Call Interface (OCI)

145 questions
0
votes
0 answers

While opening Oracle From Excel, it shows the error "The specified DSN contains an architecture mismatch between the Driver and Application"

While Opening instantclient_12_1 in Windows 7, from Excel it shows the following error. "The specified DSN contains an architecture mismatch between the Driver and Application" I will provide the Image of the error after we select the TNS from…
Dona Susan Issac
  • 170
  • 1
  • 17
0
votes
2 answers

How to Add a Local Database by Oracle Instant Client on Mac?

I'm completely newbie to the database. I successfully installed instant client for Mac, and now can use sqlplus /nolog in the terminal, but I can't log in any database because I don't have any except for some txt files, nor can I create any user.…
Ethan Sun
  • 3
  • 3
0
votes
1 answer

While installing instantclient_12_1 in Windows 10 it shows the following error

While installing instantclient_12_1 in Windows 10 it shows the following error. I will provide the Image of the error after we select the from instantclient_12_1 from Data Source (ODBC) it was the first error with follwing with next error in next…
Dona Susan Issac
  • 170
  • 1
  • 17
0
votes
1 answer

export from Excel to Oracle

I have a project where I have to send data from an Excel spreadsheet to an Oracle database. Here is the code I am using but it is not working, I am getting errors in the strSQL statements at the second string statement. I am trying to use an Excel…
hforte
  • 1
  • 3
0
votes
2 answers

Oracle instant client 12_1 + odbc Run-time Error

At work I programmed a little something in access vba to automatically create mails and send them out. To get all the information needed, I need to get access to a server of my company. Everything worked for me: Programmed the vba, installed oracle…
Marke
  • 1
  • 2
0
votes
2 answers

Microsoft - ODBC Driver Manager - Data source name not found and no default driver specified

I have developed an app in VC++ to make connect to Oracle DB and access its data. It requires a DSN to be created and some environment variables like PATH, ORACLE_HOME, TNS_ADMIN, etc. to be set which I have done programmatically in my VC++ code. I…
ModeLearner
  • 21
  • 1
  • 5
0
votes
1 answer

I am getting following error.i download oracle client and provide necessary path to env variables

import cx_Oracle Traceback (most recent call last): File "", line 1, in ImportError: DLL load failed: %1 is not a valid Win32 application.
user4542513
0
votes
0 answers

oracle instant client for python and oracle client for vba

I had been happily using the driver that comes with the oracle client to query oracle databases with the following connection: Set cn = New ADODB.Connection cn.Open ("Provider=MSDAORA;" & _ "User ID=;" & _ …
RAY
  • 6,810
  • 6
  • 40
  • 67
0
votes
0 answers

Vim dyld_library_path

I setup Oracle instant client (11.2.0.4) on my "El Capitan" OS X to use sqlplus and VORAX on VIM as IDE. From the bash is all right, I can connect to my DB with sqlplus without problem. When I open VIM and try to exececute "!sqlplus" I've the…
Massimiliano Pinato
  • 1
0
votes
1 answer

Connection to Oracle through VBA no longer working

I have been using this connection string: fn_Connection_String = "Provider=MSDAORA;Data Source=[address]:1521/orcl;User ID=xxx;Password=xxx" ...and it has been working fine. The IT company that works for my client has reported that the client is…
n8.
  • 1,732
  • 3
  • 16
  • 38
0
votes
0 answers

Can we connect to Oracle database from Unix system without OCCI?

Can we connect to Oracle database from Unix system without OCCI? Is it necessary for a Instant Client to be installed to use the Database connection? Kindly give suggestions. Thanks
Vidyasagar S T G M
  • 1
  • 5
0
votes
0 answers

oracle instantclient 12c EZCONNECT in Powershell Prompt for password

I have installed instantclient 12c x86 on Windows 8.1 I am able to connect from cmd.exe: C:\Users\vagrant>sqlplus user@\"hostname:1521/SERVICE_NAME\" SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 3 06:22:31 2015 Copyright (c) 1982, 2014,…
Bjarte Brandt
  • 4,191
  • 2
  • 23
  • 25
0
votes
1 answer

JBoss crashes on libclient64.dylib access

I´m trying to get Oracle instantclient up and running on OS X with Java 1.6.0_65. I did all steps described in the Oracle documentation: https://docs.oracle.com/cd/E11882_01/install.112/e38228/toc.htm but the problem keeps the same: Invalid memory…
Macilias
  • 3,279
  • 2
  • 31
  • 43
0
votes
1 answer

How to fix cx_Oracle: DLL load failed?

There are so many related questions that I have gone through which made me wonder how come this is such a prevalent issue? Anyways, I am trying to use cx_Oracle module. I have the : instant client: instantclient-basic-win32-11.1.0.6.0.zip python -…
codingsplash
  • 4,785
  • 12
  • 51
  • 90
0
votes
0 answers

error while loading shared libraries: libocilib.so.4: cannot open shared object file: No such file or directory

I have installed Oracle Instant Client 12.1 (basic and SDK) and Ocilib 4.0.1 on my Oracle Linux 7.1 virtual machine. $ORACLE_HOME is /usr/lib/oracle/12.1/client64 $LD_LIBRARY_PATH is /usr/lib/oracle/12.1/client64/lib:/usr/local/lib To install ocilib…
myrmix
  • 371
  • 3
  • 11
  • 25
1 2 3
…
9
10