Re: Excel 97 & AS/400 Data conversion problems

[Vern Hamberg <hambergv@xxxxxxxxxxxxxx>]

Robert

At 05:05 PM 3/31/98 -0800, you wrote:
>Hello group!
>I have been playing with downloading data to a PC from our AS/400 (V3R7 -
510). 
>Overall, this works very well, but I have run into a couple of quirks I would
>appreciate some help with.
>1. When I try to use Microsoft Excel 97 to "Get external data", I select the
>Client Access ODBC 32 bit driver.  I cannot get the data source to
recognize the
>default libraries I choose on the "server" tab - instead, it uses my AS/400
>profile's default library list.

-snip-

We've recently had to deal with this. It appears that SQL knows nothing
about library lists. If you don't qualify the table name with a library, it
will try to use the first library named in your ODBC setup.

I get a little confused when I see a list, e.g., in MS Query, that includes
different libraries, if set in the 'Eau Debussy' ;-) setup. But that
apparently does not affect the execution on the 400. It is only a
pick-list, I guess. You need to explicitly qualify the table, or set up
different ODBC sources for each library you need to get at.

HTH

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN 55401
(612) 371-1111 x480


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---