I have used Power Basic to create .csv files which I have exported into Oracle Express 11g to create a database of vendors.
I can use Power Basic and SQL Tools to access and edit the database on XE 11g and have done most of development work and training there.
In this case I use a straightforward .DSN file to for SQL tools to use with a ODBC to connect to the XE 11g all is fine and I have made great progress.
I have exported the database onto a network and into an Oracle 12C database at work.
There is a System .DSN for ODBC to connect to this database and this has been tested giving the results "connection successful".
This connection uses a driver with the file name "Oracle in OraClient 12Home1"
I have read the Oracle guide "Using the Oracle ODBC Driver" section 21 an in particular 21-26 to 21-29 which is the most relevant to what I need to do.
https://docs.oracle.com/ database/121/ADFNS/adfns_odbc. htm#ADFNS1183
I cannot get either the .DSN file referenced in the PB program or hard coded connection string in the PB program to make the connection to the 12C Database.
For example
[ODBC]
DRIVER=Oracle in OraClient 12Home1
DSN=xxxx
DBQ=xxxx
UID=xxxx
PWD=xxx
DBA=W
APA=F
RST=T
QTO=T
CSR=T
BNF=F
DRH=F
BAM=IfAllSuccessful
FBS=64000
FEN=F
FRC=10
FDL=10
LOB=T
MTS=T
FWC=F
EXC=F
XSM=Default
MDI=T
DPM=F
BTD=F
NUM=NLS
ODA=F
STE=F
TSZ=8
However I have found that if I use the "DRIVER=Oracle in XE" instead of "DRIVER=Oracle in OraClient 12Home1" text then it makes the connection to the network database.
[ODBC]
DRIVER=Oracle in XE
DSN=xxxx
DBQ=xxxx
UID=xxxx
PWD=xxx
Why does DRIVER=Oracle in OraClient 12 Home1 not work when trying to connect to the Oracle 12C database ?
Appreciate it if anyone can assist me on this.