Re: Microsoft Query

Just in case you are tired of ODBC drivers:

You can use my Oraxcel addin for Excel. It:

-comes about as a new menu item in Excel
-lets you query oracle and receive the data in your spreadsheet
-lets you browse your tables/views
-execute PL/SQL
-do inserts/updates

Have a look at:

http://members.aol.com/gjlinker/projects/oraxcel

Kind regards, Gerrit-Jan Linker

ps: Oraxcel requires OO4O which is mostly installed when doing an Oracle installation.

In article <35948e03.3249772_at_newshost.us.oracle.com>,   jkallman_at_us.oracle.com (Joel R. Kallman) wrote:
>
> On 25 Jun 1998 12:31:58 EDT, ait_at_concentric.net (JEFFKISH) wrote:
>
> >I find Microsoft Query a very useful tool. Does anyone else?
> >Unfortunately, recently for some unknown reason I lost my ability to
> >connect it to my Oracle database. I had been using ODBC 2.0 and
> >upgraded to ODBC 2.5, but the situation did not change. I am able to
> >connect and query successfully via ODBC TEST.
> >
> >When I try to connect I get a message box saying:
> >caption: Microsoft Query
> >body: ORA-01017:invalid username/password; logon denied.
> > Driver's SQLSetConnectAttr failed.
> >
>
> What version of the database and Oracle ODBC driver are you using? I
> just successfully set up a new query in MS Query using Microsoft Excel
> 97 to an Oracle8 database using the Oracle-supplied ODBC driver,
> version 8.0.4.3.0. As well, I tried this same test using the
> Microsoft ODBC for Oracle driver, version 2.73.715700. Bot of these
> worked just fine.
>
> Your problem might be your change in the driver manager. Even though
> the ODBC driver manager should accomodate older ODBC drivers, this
> sometimes can get a little flaky.
>
> Hope this helps.
>
> >Next question is, is there another tool I could use to replace
> >Microsoft query? I tried Borland(Inprise) database explorer but can't
> >seem to thet the log memo fields displayed.
> >
> >Thanks so much for any assistance,
> >Jeff Kish
> >ait_at_concentric.net
> >
>
> Thanks!
>
> Joel
>
> Joel R. Kallman
> Oracle Government, Education, & Health
> Columbus, OH http://govt.us.oracle.com
> jkallman_at_us.oracle.com http://www.oracle.com
>
> ----
> The statements and opinions expressed here are my own
> and do not necessarily represent those of Oracle Corporation.
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sun Jul 12 1998 - 23:32:15 CEST