RE: Excel and Personal Oracle 8.0.4

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Thu, 14 Dec 2000 16:08:53 -0400
Message-Id: <10710.124620@fatcity.com>

Michael,

If you can, upgrade 8.0.4 to 8.0.6.

8.0.4 will soon be de-supported, if it hasn't been already.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

> -----Original Message-----
> From: Michael Kline [SMTP:maklinesr_at_home.com]
> Sent: Thursday, December 14, 2000 2:11 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Excel and Personal Oracle 8.0.4
>=20
> I'm converting from Personal Oracle 7.2 and Office 97 to Personal =
Oracle
> 8.0.4 and Office 2000....

>=20
> My system uses an excel spreadsheet to bring data in that I've =
obtained.
> With the "old" system, I would simply click the pages to execute the =
query
> and it would run, no problems. Didn't have to use a password, no =
pausing
> except to hit the "!".

>=20
> Now it seems in Office 2000 I always have to hit the OK on the query =
as
> the
> username/password block comes up filled out... I click okay, can go =
into
> MS
> Query if I want, and when I come back out, it again gives me the =
block
> with
> the username/password, and I have to hit OK... then it populates the
> spreadsheet...

>=20
> Maybe I simply have to put up with this, but any idea why I can't =
seem to
> save the user/password any more, or more precisely, why do I always =
have
> the
> pause and have to hit the OK? Is it because the connect string used =
to be
> "2:" and now seems to be null? Is there a new connect string for =
Personal
> Oracle 8.0.4?

>=20

> Thanks.

>=20

> Michael Kline
> ThinkSpark
> Richmond, VA
> 804-744-1545

>=20

> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Michael Kline
> INET: maklinesr_at_home.com

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Dec 14 2000 - 14:08:53 CST