S
staceyupson
Wondering if it is possible to use JDBC Thin Client in VBA to connect
to an Oracle server from an MS Access database.
Bit of background:
-Access database needs to connect to an Oracle database to pull some
information. Doesn't need to write any information.
-I've been able to make a successful connection using Microsoft ODBC
Oracle driver and the Oracle driver within the VBA code.
So, why the question about JDBC? The problem is that Oracle client
would need to be installed on multiple pc's and I'm looking to avoid
that if possible and also expand my knowledge horizons. I was told
that the JDBC Thin Client doesn't require an Oracle client install.
If someone can let me know if Access-->JDBC-->Oracle DB through VBA
code is possible, that would be great. A sample code of how one would
accomplish that would be even better!
Thanks in advance.
Stacey
to an Oracle server from an MS Access database.
Bit of background:
-Access database needs to connect to an Oracle database to pull some
information. Doesn't need to write any information.
-I've been able to make a successful connection using Microsoft ODBC
Oracle driver and the Oracle driver within the VBA code.
So, why the question about JDBC? The problem is that Oracle client
would need to be installed on multiple pc's and I'm looking to avoid
that if possible and also expand my knowledge horizons. I was told
that the JDBC Thin Client doesn't require an Oracle client install.
If someone can let me know if Access-->JDBC-->Oracle DB through VBA
code is possible, that would be great. A sample code of how one would
accomplish that would be even better!
Thanks in advance.
Stacey