Re: Connecting Developer to MS-Access

From: Shilpesh <shilpesh_soni_at_yahoo.com>
Date: 6 Sep 2001 14:41:03 -0700
Message-ID: <a3742f87.0109061341.2c590ba7_at_posting.google.com>

"Aparna" <bliss_is_ignorance_at_hotmail.com> wrote in message news:<3b95017b.0_at_news.tm.net.my>...
> Hi all,
>
> Has anyone tried to connect Developer 2000 to MS-Access??? If yes what is
> the ODBC driver used? Do you set up ODBC as for any other connections (e.g.
> VB to Oracle)? Would appreciate any help / tips on this...
>
> Thanks for your attention
>
> Regards,
> Aparna
Hi Aparna,
U need to install 1. ODBC drivers for oracle and 2. ORacle OCA(Open client Adapter) drivers. Both the drivers will be in Oracle client CD. After that u need to go to control panel-> odbc connection. Create a new ACCESS profile by selecting the required MDB file and give any username and password. Now in D2K, try to connect with - <user name>/<password>_at_ODBC:<profile name>.

Hope it'll answer all yr queries. Received on Thu Sep 06 2001 - 23:41:03 CEST

This message: [ Message body ]
Next message: Don: "Deploying a java stored procedure using JDeveloper. How do I select the methods that will be a procedure?"
Previous message: Shilpesh: "Help required in Oracle reports"
In reply to: Aparna: "Connecting Developer to MS-Access"
In reply to Aparna: "Connecting Developer to MS-Access"
Next in thread: Jon Schlatter: "Re: SQLPLUS from a command prompt"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message