RE: ODBC connection

Hi

It's the default library list in the server tab of the ODBC connection
that has been set up, but when I use the ODBC connection I do not get
those libraries to select from.

Steve Dodkins
I.T Manager

ebm-papst UK Ltd
Chelmsford Business Park,
CM2 5EZ Chelmsford,
UK
Tel: +44 (0) 1245 468555
Dir: +44 (0) 1245 456510
steve.dodkins@xxxxxxxxxxxxxxx
www.ebmpapst.co.uk/index2.htm

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Guy Terry
Sent: 15 January 2008 13:26
To: 'Midrange Systems Technical Discussion'
Subject: RE: ODBC connection

Hi Steve,

In ODBC Administration, open the iSeries Data Source.

You might need to look at 'Library List' on the 'Server' Tab. I have *
in
there - if I leave it blank I only get offered QGPL.

(This is on v5r4)

Guy

-----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