Re: MS Access and Oracle 8: Help

Woohoo!!!! I'm finally getting the hang of this stuff!

Ok, I was finally able to get MS Access to connect to my Oracle 8 DB on my Sun node.

It turns out that from digging thru the Access help files that I needed to install the SQL Server component of MS Access which is NOT selected by default. I installed this component from the MS Office 97 distro.

Next, I learned that I needed to select "Machine Data Source" instead of "File Data Source" and BINGO! I was able to link my tables!!

Happy Happy Joy Joy.

I'm now having UserID/Password Invalid problems...but I'll keep digging on that.

I was also able to successfully use PERL via ODBC to my Oracle DB from my PC.

Life is good!

Thanx for all your help out there!

On Tue, 10 Feb 1998 16:50:10 GMT, jwest_at_frii.com (Jim West) wrote:

>Ok, here's a followup:
>
> Uninstall all Oracle ODBC drivers. Went back to the Oracle web and
>downloaded the latest Oracle7 ODBC driver. I had previously
>downloaded the Oracle8 ODBC driver but then noticed that it was listed
>to work with Net 8 Clientl, which I don't believe we have. The
>Oracle7 ODBC drivers were listed to work with SQL*Net, which we do
>have.
>
> Here are my particulars:
>
> On the PC:
> Windows95
> MS Access 97 (Office 97)
> SQL*Net Client 2.3.2.1.6A
> Oracle7 32 bit ODBC Driver (Production) 2.5.3.1.0B
>
> For the DB:
> Oracle8 Enterprise Edition Release 8.0.3.0.0 - Production
> with the Partioning and Objects option
> Sun E5000 running Solaris 2.5.1
>
>Ran the SQL*Net Easy Config and set up my alias. Then ran the ODBC32
>Admin and set up a User DSN tied to the alias I provided to SQL*Net.
>
>SQL*Plus 3.3 works ok.
>Tested with the ODBC Test Tool. It to connects and works ok.
>
>Fired up MS Access, created a new DB. From the Tables tab, I selected
>New and then attempted to both import and link tables from "ODBC
>Databases".
>
>I select my DSN, get my login prompt, enter my password, hit <RETURN>
>and whammy! I get "Reserved Error (-7778) Not text for error
>message".
>
>So...I ask you, oh great Oracle wizards, what am I doing incorrectly
>here!
>
>Thanx for any and all help.
>
>
>On Mon, 9 Feb 1998 19:19:01 -0500, "venkata terala"
><venkata_at_inetnow.net> wrote:
>
>>Jim,
>>All you need is an Oracle driver and SQL*Net configured on the client.
>>Configure tnsnames.ora (Oracle_Home\Network\Admin\Tnsnames.ora) on the
>>client. A Listener should be running on your server for the database you
>>want to connect to. In the ODBC DSN configuration, provide the service
>>name/dbalias (from the Tnsnames.ora) of your database.
>>Regards
>>venkat
>>
>>> I would like some help from some kind soul in connecting MS Access
>>>to my Oracle 8 database.
>>>
>>> Is there an FAQ and/or a step-by-step HowTo to assist me in this
>>>endeavor?
>>>
>>> I have Oracle 8 running on a Sun node (Solaris). MS Access 97 on
>>>Windoze95.
>>>
>>> I understand that I will need an ODBC driver for this. My PC
>>>currently has loaded, Designer/2000 and SQL*Net. What else do I need
>>>to gain access to my DB via MS Access?
>>>
>>> Much thanx!
>>
Received on Wed Feb 11 1998 - 00:00:00 CST