RE: ODBC connection

I seem to remember that my library list was not working when it was invalid.

Have you checked that it's comma-separated (just in case, with no spaces) and that all the library names are still valid, and that you have access to them?

If that fails, turning tracing on may also give you some additional clues.

Good luck,

Luis

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steve Dodkins
Sent: 15 January 2008 13:04
To: Midrange Systems Technical Discussion
Subject: ODBC connection

Hi
I have an ODBC connection set up on my PC (iSeries V5R2M0, PC XP Pro
and Office 2007 patched up to date) which has worked fine, I am using
Excel 2007 and am attempting to download data in excel from other
sources and then select the Microsoft Query - Select Data source - which
is the ODBC connection I've created some time ago, but now instead of
showing the library list from the ODBC connection I get a default
library list which does not contain any of my libraries set up in the
ODBC connection.

Client Access data transfer is also at V5R2 and I've reinstalled it just
in case and the iSeries user has not changed either.

Can anyone point in the right direction to be able to use the default
library list from the ODBC connection?

Steve Dodkins
I.T Manager