Re: Connect to Oracle with VBA

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 01 Mar 2006 23:09:19 +0100
Message-ID: <lp6c02hq6rd3dtnfdpfggijuqj3eq97122@4ax.com>

On 1 Mar 2006 12:36:39 -0800, "RLN" <rlntemp-newsgroup_at_yahoo.com> wrote:

>If I use the Microsoft driver for Oracle, is it possible to connect to
>an Oracle DB using straight VBA code inside of Access and not having to
>mess with configuring the user's workstations with an ODBC data source,
>TNSNames.ORA file, etc.?

I know it is very difficult for you to remember and mention versions, yet is is required for most answers. Without versions, the answer is obviously going to be a flat 'No', apart from that: setting up a tnsnames.ora is not difficult.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Mar 01 2006 - 16:09:19 CST